Ensure that File Name Save As Different Name than Current File Name

[dluhut]

Hello Excel VBA Experts.

When the user do a 'Save As', how do I force a user to have the file save as a different name?

i.e If the file name is 'Book1.xlsx', I'd like the user to save it as a different name such as 'Test.xlsx'...Anything that starts with 'Book' is not accepted.

[KOKOSEK]

I am not sure that you will be able to force but you can suggest by putting into ThisWorkBook code:

Please Login or Register  to view this content.