MrExcel Publishing
Your One Stop for Excel Tips & Solutions

File Protected, Want to Unprotect


Posted by Dick Scherer on November 07, 2001 9:24 AM

I had a power outage while the file was open. When I tried to open the file after the outage I get a message that the file is protected and can only be opened as "read only". When I go to Tools it does not give me the opportunity to switch to Unprotect. It only shows the Protect.


Posted by Rick on November 07, 2001 9:46 AM

Try doing a SAVE AS and name the "read-only" file a different name. then close down and read in the newly named file.

Posted by Dick Scherer on November 07, 2001 11:45 AM

That works but now how do I delete the old file. I get the same protect type message when I try to delete.