|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 17th, 2009, 07:22 PM
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
June 17th, 2009, 08:10 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
