Unlock worksheet
 

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

Unlock worksheet
 

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?

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?

Unlock 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

"Gordy" wrote:

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?