View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gordy Gordy is offline
external usenet poster
 
Posts: 5
Default Unlock worksheet

Yes it is a shared workbook, it is a downloaded workbook as part of a
tutorial lesson.
The symbol at the top of the Changes group can be changed from Protect
Shared Workbook or Unprotect Shared Worksheet.
I have it set at showing Protect Shared Worksheet, so I assume that it may
be shared.
They Unprotect Sheet is still grayed out and it will not allow me to make
changes to the worksheet.

"Mike H" wrote:

Is the workbook shared?

If it is then un-share it and then unprotect the sheet.

Mike

"Gordy" wrote:

How do iunlock a worksheet if the Unprotect Sheet symbol is grayed out?