G
Gordy
How do iunlock a worksheet if the Unprotect Sheet symbol is grayed out?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Is the workbook shared?
If it is then un-share it and then unprotect the sheet.
Mike
If it is then un-share it and then unprotect the sheet.
Mike
G
Gordy
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.
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.
M
Mike H
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
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