Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I forgot to answer the below question:
The strange thing is, when I comment out the entire code, I still get the error. I beleive this is because the normal function of double-clicking a cell is to enter Edit Mode. This is not allowed for locked cells when the sheet is protected. Therefore, this should cause an error message whether you had created code or not. However, I wouldn't expect you would get the same message. Rather, somthing to the effect that you can't change protected cells. I get: "The cell or chart you are trying to change is protected and therefore read-only..." Regards, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I use the subtotal function while a worksheet is protected? | Excel Worksheet Functions | |||
Using solver function in a locked (protected) worksheet | Excel Worksheet Functions | |||
Using Spell Check function in text box when worksheet is protected | Excel Discussion (Misc queries) | |||
Tab Function in Protected Worksheet | Excel Discussion (Misc queries) | |||
Group Function on a Protected Worksheet | Excel Programming |