I have a workbook (with VBA code) that I don't want the user to be able to save over. If the user wants to save the work they have done so far in the workbook, they will need to save it under a different name.
I'm assuming this will include the "before save" event. But past this, I don't know where to go.
As an example of what I would like the code to do:
The original file name is "ExampleFileName.xls"
The user goes to save (either under 'save as' or 'save') and attempts to save the file under its original name ("ExampleFileName.xls"), then I want to prompt the user with a msgbox telling them that they can't save the file under that name and that they will need to go back and save it under a different name.
Any advice? Thanks.
Bookmarks