I've done some more research and testing on my own (since I haven't gotten any new replies lately!) I thought I had it figured out with the addition of
at the end of my Submit button code, BUT although the form now still auto-saves and then does autoclose, when I re-open it the contents of the userform fields have not cleared! I thought that if I placed the additional code AFTER the ClearContents code, everything would work! Does anyone have any ideas??? The code for my Submit button is below, with the additional Save and Close code added:
Bookmarks