can't use ThisWorkbook.SaveCopyAs in combination with passwordprotection

[jokkebal]

I can use

Please Login or Register  to view this content.

and also

Please Login or Register  to view this content.

But somehow, the combination always gives an error. Why ?

[romperstomper]

Because SaveCopyAs only takes a file name argument. You can't change anything else about the file.

[jokkebal]

Hi Rory,

Thanks for your reaction. Any solution ?

[romperstomper]

You'd have to use SaveAs and then reopen the original, or use SaveCopyAs, and open the copy, change the passwords and save and close it again.

[jokkebal]

Can I do all that via VBA, and finally have that file closed and my original file open ?
Put another way, can VBA do all this "in the background" ?

[romperstomper]

Yes. It just depends what state you want the current workbook left in.