Solved: write reserved

[philfer]

Hi,

I have a workbook that has a password to modify on it.

I recorded a macro that re-saves it over the existing file and I click "yes" when it says file xyz already exists etc etc

However when I put this recorded macro into my code it falls over at this point and says the file is write reserved even though the recorded macro passes the write reserved pasword.

I added displaywarnings = false but it still falls over at this point

Any help?

[Simon Lloyd]

Phil its [VBA]Application.DisplayAlerts=False [/VBA]but can you supply the code you are using?

[philfer]

Sorry, I meant diplayalerts

The code is basically a recorded macro if you have a file open with a password to modify password open then save as the save filename and when it asks you to replace it say yes.

I then paste this into my code and it breaks!!

[Simon Lloyd]

Phil i ask you again....can you supply the code you are working with, it's almost impossible to help without seeing what you are currently doing!