If a value in cell $B$1 is greater than 50 I want to lock range of cells B40:B44 to prevent it from data entry. However I need a macro so I can click to unlock to those cells later on without changing the value in cell $B$1 in order to process the worksheet later on.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Lock and Unlock Cells
- Thread starter tiomin
- Start date
Similar threads
- Solved
- Question
