checkbox in a protected worksheet
 

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?

checkbox in a protected worksheet
 

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


--
Cheers,
Shane Devenshire


"Eric Wixom" wrote:

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?

checkbox in a protected worksheet
 

Genius! I cant believe I didnt think of that!

Thank you!


"ShaneDevenshire" wrote:

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


--
Cheers,
Shane Devenshire


"Eric Wixom" wrote:

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?