Unprotect worksheet is greyed out. How do I make it available?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I protected the worksheet and made some cells available and others off
limits. Now I want to make some changes to the spreadsheet but
Tools/Unprotect Worksheet is unavailable. I did not password protect the
sheet.
Appreciate any assistance on this.
Thank you.
 
Do you have multiple sheets selected?
Look for [Group] in the title bar. Rightclick on a worksheet tab and choose
"ungroup sheets".

Is the workbook shared (via tools|share workbook)?
Look for [Shared] in the title bar.
There are lots of that can't be done in a shared workbook. You'll have to
unshare the workbook to unprotect the worksheet.
 
Back
Top