How to Save As a password-to-open workbook without a password?

Hello,

I have a macro that opens a workbook that has a password to open and then saves a new copy of the file. The problem is, the newly saved file still has the same password to open, but I need it removed. The closest thing I have found is ActiveWorkbook.Unprotect Password:="mypassword." I tried this but it did not work for a password to open (I assume it unprotects workbooks that are only partially protected).

Here is the relevant snippet from what I am currently using:

Please Login or Register  to view this content.

Any help would be greatly appreciated. Thanks in advance!

Before you SaveAs, delete the password:

Please Login or Register  to view this content.

Then, put it back after the SaveAs:

Please Login or Register  to view this content.

So obvious in retrospect. Thank you!

My pleasure!