Don't save with same name

[rpinxt]

Well like the title says.
I want to make it impossible for the user to save the workbook with exactly the same name.
So I want to force him to make a new name.

Can this be done without VBA or not?

[than_gold]

Usually when you try to save any file in same name you will get a warning message?!

[than_gold]

Try this in This workbook module.

Please Login or Register  to view this content.

[rpinxt]

Ehm...yes that is true then_gold....
But does that mean the user will also choose another name?

Just want to make sure the user does not overwrite the original file.

[rpinxt]

Thanks for the VBA code.
So this only can be done with a macro?

[than_gold]

keep the file as read-only, so when they open & do some changes, they will ask to save another name. But here they can't overwrite the original file.

[rpinxt]

Hmm yes (can't believe I forgot about that) but then nobody can update the original file when it needs to be updated under the same name correct?
Or that can be of course handled with a password I guess.

[than_gold]

Yes, when file in read only, no one can updated the original file.
Keep a password for that file, so who know pwd can update the original file.