Hello Rmagic,


Code
-------------------

If CheckBox1.Value = True Then
OptionButton1.Value = False
OptionButton2.Value = False
OptionButton1.Enabled = False
OptionButton2.Enabled = False
Else
OptionButton1.Enabled = True
OptionButton2.Enabled = True
End If

-------------------


Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48451