| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking cells dynamically
Here is what I am trying to do:
I have protection set up so that the user can only enter unlocked cells. If a certain cell (Say B12) contains "no", I want another cell (say C12) to be unlocked, so the user can cursor to it. If that same cell (B12) contains "yes", I want the cell (C12) to be locked so the user cannot cursor to it. Is this possible? Thanks, Dean |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically Activating Cells | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Dynamically locking a cell depending upon value of another cell. | Excel Discussion (Misc queries) | |||
| How to reference cells dynamically | Excel Discussion (Misc queries) | |||
| Locking cells dynamically | Excel Discussion (Misc queries) | |||
Threaded Mode
