Excel 2002 wont unprotect

  • Thread starter Thread starter Nelson
  • Start date Start date
N

Nelson

Help!! Too much tinkering on the Excel file eventually
led to this dilemma... I cant unprotect the file. I
remember:
1. protecting each worksheet from Tools/protect worksheet.
2. and then "Protected and shared" the entire
workbook....

now when the file is opened, I can see the "Unprotect
Shared Workbook" but the "Unprotect Sheet" is greyed even
though after I unprotected the shared workbook. I just
cant find any resources to unprotect this file anymore.
Please help.
 
You must unshare the workbook before you can unprotect sheets. Tools, Share
Workbook and uncheck the Allow changes... checkbox.
 
-----Original Message-----
You must unshare the workbook before you can unprotect sheets. Tools, Share
Workbook and uncheck the Allow changes... checkbox.

--
Jim Rech
Excel MVP


.Thanks soo much. I think it was that simple . MVP!!
Click to expand...
 
You must log in or register to reply here.

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

Unable to unprotect an Excel Worksheet 2
Qualifying permissions in protect unprotect macro. 3
Unprotecting what Excel says is unprotected ??? 2
Why does Excel unprotect all my sheets when I hit save? 1
Unprotecting worksheets 2
Cannot unprotect workbook with an Excel crash 0
Excel 07 Protection 3
Unprotect workbook 3

Back
Top