Hi i have tried the code (thanks for that)
Private Sub CheckBox1_Click()
If Range("N22").Text = "1" Or _
Range("N22").text = "2" Or _
Range("N22").text = "3" Then
CheckBox1.Value = False
CheckBox1.Enabled = False
Else
CheckBox1.Value = False
CheckBox1.Enabled = True
End If
End Sub
But it only works once and still remains locked after change the numbe
to say 4 or 5
Thank
--
Rmagi
-----------------------------------------------------------------------
Rmagic's Profile:
http://www.excelforum.com/member.php...fo&userid=2859
View this thread:
http://www.excelforum.com/showthread.php?threadid=48467