Lock cell control conditionally?
I would like to choose or lock an option button selection based upon the
values in another set of option boxes.
Example:
OptionButtons 1, 2 & 3 are in one group
OptionButtons 4 & 5 are in a second group
If OptionButton1 is true, then OptionButton5 must be true
If OptionButton2 is true, then OptionButton4 or 5 can be selected
If OptionButton3 is true, then neither OptionButton4 or 5 can be selected
Any ideas?
|