Paul Benet
New Member
- Joined
- Aug 2, 2010
- Messages
- 3
Hello everyone,
I need some help for VBA code to be able to un-lock/allow selection and editing of cells in range E3:CG106 on 5 different worksheets in my workbook only when those cells are conditionally formatted to green (color index = 14), the conditional formatting on these 5 sheets is based on formulas and values entered in separate worksheets. All other cells throughout these 5 worksheets in range E3:CG106 should remain locked/protected unless formatted to green 14.
The tricky part for me to get my head around is that as the formatted colors of the cells in the range E3:CG106 of each worksheet change I need the cell locking/protection to change 'real time' when the conditional formatting changes, can this be achieved?
Greatly appreciate assistance/suggestions!
Thanks, Paul
I need some help for VBA code to be able to un-lock/allow selection and editing of cells in range E3:CG106 on 5 different worksheets in my workbook only when those cells are conditionally formatted to green (color index = 14), the conditional formatting on these 5 sheets is based on formulas and values entered in separate worksheets. All other cells throughout these 5 worksheets in range E3:CG106 should remain locked/protected unless formatted to green 14.
The tricky part for me to get my head around is that as the formatted colors of the cells in the range E3:CG106 of each worksheet change I need the cell locking/protection to change 'real time' when the conditional formatting changes, can this be achieved?
Greatly appreciate assistance/suggestions!
Thanks, Paul