A
andreashermle
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
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