Check Box to call Macro
John,
In your code, change "CheckBox" to "CheckBox1":
CheckBox1 = True Then
hth,
Doug
"John" wrote in message
...
Could someone help me understand why if I click my check box it doesn't
call
or run my macro... here is the code.
Private Sub CheckBox1_Click()
If CheckBox = True Then
Application.Run "Bond Price Calculator.xlt!GovtClick"
'or call GovtClick
Else: End
End If
End Sub
|