ExcelBanter - Check box control

This would prevent the value from changing if the condition is met, however,
the checkbox is linked to another cell which has a formula that is supposed
to automatically change the value to 'true' or 'false' depending on user
input. If the user clicks the checkbox, it may not change based on the
sub-routine below, but will change the formula to the value of the checkbox,
thus rendering the box useless. This document contains 14 pairs of
checkboxes, 5 of which I would allow the user to select one of the two,
having the other value change based on the user selection, the other 9 pairs
are updated based on other data entered into the form elsewhere. If there is
another way to go about this instead of using checkboxes, please let me know.
Thanks.

"Jim Cone" wrote:

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?