Check Boxes on Protected Sheet

J

John

I have a protected sheet that contains checkboxes.
Checking a box results in the following error
message: "The cell or chart you are trying to change is
protected and therefore read-only." When you
select "okay" the change does actually occur, so it is
not protected. How dow I keep from encountering the error
message. I want to be able to check the box while the
sheet is protected. Allowing the user to edit objects
does not fix the problem.
 
C

CBrine

You have your checkbox control associated to a cell on a protecte
worksheet. That cell must be unlocked for your control to update th
value
 
Top