Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking and Unlocking Cells via VBA
Dear Experts:
I would like to achieve the following on the ACTIVE workseet by applying a VBA code: 1. Lock all the cells of the current worksheet that would be selected by pressing Ctrl+Shift+End 2. De-lock those cells that require data entries by the user, i.e cells where data entry is restricted to certain values (by data validation) Help is much appreciated. Thank you very much in advance. Regards, Andreas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking/unlocking cells based on column headers | Excel Programming | |||
Unlocking and Locking in a Marco | Excel Programming | |||
locking and unlocking worksheets | Excel Worksheet Functions | |||
Locking/Unlocking cells upon condition | Excel Discussion (Misc queries) | |||
Locking/unlocking cells | Excel Programming |