unprotect sheet (icon is greyed out)

D

dj888de

I put a protection on the sheet so it is a read only, but I need to go back
in and unprotect it to change some of the cells. The icon is greyed out so
it won't even allow me to enter in my password to unlock the sheet. Can
someone please help me?
 
G

Gord Dibben

Is the workbook also shared?

Do you have more than one sheet selected?

Either of those will prevent unprotecting.


Gord Dibben MS Excel MVP
 

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

I am trying to assign resources to tasks but the 'Assign Resources' is greyed out on the Resource tab. 0
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Insert Menu Greyed Out 0
What type of inboxes do these icons represent 0
Menu Macro Not Executing - Need Help 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Unable to Unlock Workbook 1
need help ASAP word 2016 recipient cant edit 0

Top