So I have several checkboxes on a sheet that I need in order to change the value of an assigned cell. To prevent users from changing values in the cells themselves, I would like for the cell to be locked when the sheet is protected.

At this point, when I lock and protect the sheet and click the checkbox, the following error appears.

Capture.JPG

If there is a code that will change the value of a cell on different sheet, that would be great. In fact, I imagine that would be much easier.