| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
locking cells based on results at runtime
hi,
how a cell or a range of cells be locked based on another cells value? let me explain if cell(A1)'s value is less then 30 then cell(b2) or cells b2:b10 must be locked. user must not be able to do anything then on these cells. othewise it must be open for editing. aken |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing cells that return blank results | Excel Worksheet Functions | |||
| Cells displays formula, not results | Excel Worksheet Functions | |||
| I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
| how do you format a row of cells based upon a value in another ce. | Excel Discussion (Misc queries) | |||
| conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
Threaded Mode
