[Anonymous]

Thank you for the code Steve!    I have been running with the following for a few days now and it seems to be working as intended (save the spreadsheet with each patient change):

D.t.appl.ActiveWorkbook.Save

thanx,  sherry