Share via

Checkbox Error Changing

Anonymous
2016-07-18T04:55:31+00:00

I'm trying to check my checkbox in excel and it says:

The cell or chart that you are trying to change is protected and therefore read-only.

What should I do? My sheet is not protected so I can change any content of every cells. Only the checkbox that is not changed (checked).

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2016-07-18T07:21:48+00:00

Hello,

that's strange. A protection message should only come up if the sheet is protected. Are there any other sheets involved? Hidden sheets might contribute to the solution and might be protected.

Make sure to unhide all sheets, then make sure that all sheets are unprotected.

If the issue still persists, please post a copy of the file (replace any confidential data like names, phone numbers, email addresses with dummy text) to you OneDrive public folder, share it and post a link here.

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-18T07:48:03+00:00

    Thank you for guiding. It's my first time to visit the community. Thank you again!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-07-18T07:42:41+00:00

    Glad I could help. Plese mark my post above as the answer, so others can find it more easily.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-07-18T07:34:46+00:00

    Thank you so much ma'am. My checkbox is connected to the second sheet that is protected. Thank you for your help.

    God bless you!

    Was this answer helpful?

    0 comments