Exclude password to modify from copies when using SaveCopyAs

Hi All

For clarity, this is not a question on bypassing passwords or security, this is about applying the security only where it is required.

I have a template file which I have protected using (Save As > Tools > General Options > Password to Modify). Changes should only be saved to copies, not to the original.

When I modify the file and manually Save As from the menu, the password protection is not applied to the new file, which is what I want.

When I do the same thing using SaveCopyAs in vba, the password protection is also applied to the copy, this I don't want.

Is it possible to save copies using vba without having the password applied to them? Other users should be free to manipulate the copies as needed without entering the password.

Please Login or Register  to view this content.

Where Folder, SubFolder and FileName are variables based on the changes made.

Thanks in advance for any suggestions.

Edit:- I looked as Save As instead of SaveCopyAs, but given that the code is looping and creating multiple copies with varied parameters, I can't see that it will work.

Hi Jason,

What is happening if you use SaveAs (stringFilename, WriteResPassword:="")