vba to lock columns b thru d based on value selected in col a
This code needs to apply to one row at a time.
Column A - each cell has data validation -- possible values of Yes and No.
If the user chooses 'Yes' in A1, I need to unlock B1 thru D1 (and keep them
that way), otherwise those cells should be locked.
Same thing on row 2, etc, down to possible 300 rows or more.
--
thanks for your assistance,
cm
|