Cannot remove password from file

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Unlock Excel Workbook protected by MACRO Password 6
Remove password 4
VBA Project Password Changed on its own?!?! 0
Excel Protection 2
changing a file password from something to nothing 3
Overridding the "already exists" message with the SaveAs method 4
Controlling the file 1
Editorial How to create secure passwords 6

Back
Top