checkbox in a protected worksheet

E

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?
 
S

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
 

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

Similar Threads

Can't Get Objects To Work In A Protected Worksheet 2
how do I protect a worksheet and still use a checkbox control 4
Insert/ delete row in protected worksheet 7
Allow users to edit ranges for VBA objects 6
Protected sheet, On Enter moves next. Can I stop this? 3
Sorting Protected Worksheet 4
I can still select & manipulate locked & protected cells in '07 1
checkbox value read out 2

Top