| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn a range of cells into 'read only'
I want to turn a range of Sheet1 cells into 'read only' when my file
is saved. The conditions are as follows: If range A1:A100 (a range of dates) = TODAY() Then range C1:C100 which corresponds to TODAY() is made 'read only' I don't know if it matters, but the sheet will be password protected. Can you help with a macro for this? Thanks. Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn of 'Read Only' | Excel Worksheet Functions | |||
| How do you turn on the voice read back of excel cells in spreadshe | Excel Worksheet Functions | |||
| Turn off read only attribute on shortcut | Excel Programming | |||
| Turn off Read-Only | Excel Programming | |||
| Turn off pasting in range of cells | Excel Programming | |||
Threaded Mode
