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

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.

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

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.

kbend3r wrote:

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.

--

Dave Peterson