Another week, another attempt to find the answer to my dilemma...I've spent half the day today researching the web and testing a number of suggested codes, placed in ThisWorkbook, that are supposed to automatically save, then close the workbook, either immediately or after a period of inactivity. I keep having the same problems with all these codes: either it does appear to save and close, but when I re-open the workbook, the fields of my data entry form have not cleared (this function works in the uploaded .xls file back on page one), OR I get a Save dialog (which I don't want!), then after I close and re-open, again no clearing of contents. I am at my wit's end to figure this out, and ready to just release it for our company use and people will just have to remember to close it on their own!!! Can ANYBODY help me with this, please, please, pretty please with sugar on top??? Thank you!
Bookmarks