Worksheets and Control Option Buttons

K

KHaydel

I am running Excel 2002. I have a Workbook with 4 worksheets. I created a
Control Option Button (OptBtn01) on Sheet1. I have a Control Check Box
(ChkBx01) on Sheet4. I would like to change Control Check Box (ChkBx01) to
disabled (Enabled = False) whenever the Control Option Button (OptBtn01)
Value is True. Can anyone help?

Thanks in advance.
 
D

Dave Peterson

I put this under sheet1:

Option Explicit
Private Sub OptBtn01_Change()
Worksheets("sheet4").OLEObjects("ChkBx01").Enabled _
= CBool(Me.OptBtn01.Value = False)
End Sub
 
Top