Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unprotect sheet (icon is greyed out)
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unprotect sheet (icon is greyed out)
Is the workbook also shared?
Do you have more than one sheet selected? Either of those will prevent unprotecting. Gord Dibben MS Excel MVP On Wed, 17 Jun 2009 11:22:01 -0700, dj888de wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotect sheet command - How do I do this? | Excel Worksheet Functions | |||
Can't set page orientation - icon is greyed out! | Setting up and Configuration of Excel | |||
how to Unprotect sheet | Excel Discussion (Misc queries) | |||
Unprotect worksheet is greyed out. How do I make it available? | Excel Discussion (Misc queries) | |||
Unprotect sheet button!?? | Excel Worksheet Functions |