| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting non contiguous cells
I am trying to protect all cells in a range with a value 0 so that users can
only input into the non blank cells in the range. I've tried this Sub test() Range("A2:I10").Select If Value = 0 Then Cells.Locked = False End If End Sub but it Unlocks all cells on the Worksheet so I'm obviously doing something very wrong. I'd be grateful for some help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non-contiguous cells | Excel Discussion (Misc queries) | |||
| counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
| XIRR and Non Contiguous Cells | Excel Discussion (Misc queries) | |||
| How do I count non-contiguous cells? | Excel Worksheet Functions | |||
| Testing for contiguous cells | Excel Programming | |||
Threaded Mode
