File will have a base name that needs to be maintained
Worksheet has button to link to macro.
Macro needs to:
Protect sheet and save with base name plus a number (progressive)
i.e. First save: alsmith1 Second save: alsmith2
and then do another save (with certain named cells unprotected)
File name to be base file name plus “Ready for update” plus last progressive number plus one
i.e. After the first save, the file name would be “alsmith Ready for update 2”.
After the second save, he name would be “alsmith Ready for update 3”
Bookmarks