SaveAs Macro Fails When Workbook has a Password

[warriorwoman]

I have a macro running that creates a new version on each save and then overwrites a master file. It’s a way to handle version control so that I always have access to the revised versions and the master is always the latest file.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
It works fine until I introduce password protection to either the versions or the master.<o></o>
<o> </o>
I’ve tried using the following but it doesn’t seem to work:<o></o>
<o> </o>
.SaveAs MasterFilePath & MasterFileName, FileFormat:=FileFormatNum, WriteResPassword:="password"

I get the error message telling me the file is write-protected.<o></o>
<o> </o>
Any help would be appreciated as the password protection is quite important.<o></o>

 

[warriorwoman]

I've just been working on this a bit more and it appears that my code is saving the spreadsheet with the write reserve password of "password".

When I come to run the macro for a second time it fails because it is unable to write over a file with a password.

Is there a way to get around this?