Nulling a option button

K

Keri

I would like to "NULL" a group of option buttons if a cell
in the work book is "TRUE" and "ENABLE" a group of option
buttons if that cell is "FALSE" Any ideas??

Keri
 
B

Bob Phillips

Keri,

Do you mean

If Range("A1").value = "TRUE" Then
Activesheet.OptionButton1.Enabled = False
Activesheet.OptionButton2.Enabled = False
Else
Activesheet.OptionButton1.Enabled = True
Activesheet.OptionButton2.Enabled = True
End If
 
Top