Unable to Unprotect a 2003 .xls file

R

r25ramirez

My company recently upgraded to 2007. I had a file that was protected and
only certain cells could be modified, for data entry. I now need to
manipulate the file but I am unable to unprotect the file. The “unprotect
sheet†button is not available. How do I unlock the protection?
 
J

Jim Thomlinson

If the file is shared you need to unshare it first as that option is not
available in shared workbooks...
 
R

r25ramirez

Nope. nothing happend. A window popped up at the top of the screen looking
like it was accepting the code, but nothing happend. Thanks for the help
though.
 
R

r25ramirez

That's what it was! thank you so much! I was freaking out thinking I had to
create this file over again from scratch! Thanks again!
 

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

Top