PDA

View Full Version : [SOLVED] Remove the password protection on a file



austenr
02-17-2005, 11:14 AM
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.:dunno

mvidas
02-17-2005, 11:23 AM
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
02-17-2005, 03:38 PM
Thanks. I found it soon after I posted. Been to busy to get back and mark it solved.