| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking cells using VBA based on other cell values
Hi,
I'm trying to lock cells in a column on an excel spreadsheet depending on the (date) value in another cell on the same row. For example, I'm thinking of it like this: If range("C9").value today() Then range("G9").lock = false Else range("G9").lock = true End if However I want to do it for all rows between 9 and 400 whenever the sheet is accessed. Can anyone help? Many thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking a cell based on a cells content | Excel Discussion (Misc queries) | |||
| Excel Locking cells based on value in another cell | Excel Discussion (Misc queries) | |||
| locking cells based on results at runtime | Excel Worksheet Functions | |||
| locking cells based on condition | Excel Programming | |||
| Locking other cells based on values in a cell. | Excel Programming | |||
Threaded Mode
