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.
How about saving your file as a Template?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I'm not sure what you mean. Can you explain why I would want to do that?
Also, I don't know what a template is.
Excel's help system can explain a Workbook Template better than I can.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
OK, I see now. But, as I am testing it...excel does allow me to save over a template file. Do I have to set some option that restricts me from saving over the file?
Make it read-only.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks