Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional cell protection
If the value in cell A1 <= 0 I want to be able to change the protection on
another range of cells from unlocked to locked. Any ideas how this can be done? -- Thanks Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional cell protection
use the change event or the calculate event. It depends on how the value
will become less than zero. http://www.cpearson.com/excel/events.aspx beyond that, you have to unprotect the sheet and set the locked property to false (or true) then reprotect the sheet. Code can be captured with the macro recorder if you are not familiar. -- Regards, Tom Ogilvy "Paul J" wrote: If the value in cell A1 <= 0 I want to be able to change the protection on another range of cells from unlocked to locked. Any ideas how this can be done? -- Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set conditional protection to a cell | Excel Discussion (Misc queries) | |||
Conditional Cell protection | Excel Discussion (Misc queries) | |||
Conditional Cell Protection | Excel Programming | |||
Conditional Cell Protection | Excel Discussion (Misc queries) | |||
Conditional formating - cell protection | Excel Discussion (Misc queries) |