View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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