Unlock worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Mike
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from unlocked cells 3
Unable to unprotect an Excel Worksheet 2
Spell Check Unlocked Cells Only 9
Password Protection Bug 2
Protecting Worksheet - Cannot move between cells. 2
Can't move between cells. (Not the scroll lock) 1
How to I reset a forgotten Excel worksheet protection password? 3
Entering photos or pdf into a protected sheet 1

Back
Top