Unlock worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Try,

Tools|Share workbook

Remove the checkmark and that should allow you to unprotect. You will of
course have to re-share it when you've done what you want to do.

Mike
 
Back
Top