Code goes in the worksheet module.
'-------------
Private Sub CheckBox1_Click()
'If condition not met then checkbox value is False.
If Range("H49") < 100 Then
CheckBox1.Value = False
End If
End Sub
'-----------
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Robert Blankenship"
<Robert
wrote in message
What can be done to prevent the checkbox control from dimming when you
disable it? I need to prevent users from checking this box, yet allow the
box to be checked based on user input elsewhere. It appears that the dimming
is based off of the MS Windows System settings. This form is to be used by
other users on other machines. Protecting the document and the control, with
the control enabled does not prevent the user from selecting the checkbox.
Is there another way of preventing a user from checking the checkbox without
having to disable(dim) it?