Check Boxes on Protected Sheet

  • Thread starter Thread starter John
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top