View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carl R. Carl R. is offline
external usenet poster
 
Posts: 1
Default 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?