Jay,
You need an Unprotect / Protect routine in your checkbox procedure.
Something like:

Private Sub CheckBox1_Click()
ActiveSheet.Unprotect ("password")

"YOUR CODE HERE"

ActiveSheet.Protect ("password")
End Sub

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=397242