Remove the password protection on a file

[austenr]

This is really not a VBA problem, but I need someone to tell me how you remove the pop up box when you open the file that asks for a password. I have the password and can get in the file I just want it removed. Yes, I tried Tools>Protection. Thanks in advance.

[mvidas]

Hi Austenr,

After opening the file (with password), go to File / Save As. In the saveas dialog, go to Tools (top right of dialog window), then General Options. Remove any passwords in "Password to open" and "Password to modify". Click ok, then save. Overwrite the old file, and you're good to go.

Matt

[austenr]

Thanks. I found it soon after I posted. Been to busy to get back and mark it solved.