checkbox in a protected worksheet

[Eric Wixom]

I need to protect a work sheet that has checkbox's in it. Once protected
though there is a warning screen that pops up every time you click on a check
box that states "The cell or chart you are trying to change is protected and
therefore read only." The checkbox is unlocked, as well as the cell it is
displayed in. The checkbox is still checked/unchecked, but I don't want the
popup to appear.

Any way around this?

 

[ShaneDevenshire]

Hi Eric,

with a Form control -
The checkbox results are linked to a cell, that cell needs to have its
Locked property set to off. Format, Cells, Protection.

with a Control Toolbox control -
Alternatively, you can code the action of the checkbox with VBA. In that
case protect the sheet using vba:

Sub myProtect()
Sheet1.Protect userinterfaceonly:=True
End Sub

 

[Eric Wixom]

Genius! I can’t believe I didn’t think of that!

Thank you!