Cannot remove password from file
 

I have a file that has a password. I enter the file and then SaveAs.. and
blank out the password and save the file. When I reopen the file it still
asks me for the password. Why is this?

Thank you,

Steven

Cannot remove password from file
 

You can't just blank out the password from the code and make it go away. You
have to unprotect the worksheet or workbook.

ThisWorkbook.Unprotect "password"

or

ActiveSheet.Unprotect "password"

Then save the file, close and re-open. It should not ask for the password.

"Steven" wrote:

I have a file that has a password. I enter the file and then SaveAs.. and
blank out the password and save the file. When I reopen the file it still
asks me for the password. Why is this?

Thank you,

Steven