Cannot remove password from file

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
 
J

JLGWhiz

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.
 

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
changing a file password from something to nothing 3
Test if a file has a password 3
Controlling the file 1
File SaveAs 1
getObject and password protected workbook 4
including macro in protected worksheet 2

Top