| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox to open another worksheet | Excel Discussion (Misc queries) | |||
| How to insert a CheckBox in a Excel 2007 worksheet?? | Excel Worksheet Functions | |||
| How do I keep my checkbox from moving after I print the worksheet | Excel Discussion (Misc queries) | |||
| checkbox and worksheet | Excel Discussion (Misc queries) | |||
| how do I protect a worksheet and still use a checkbox control | Excel Worksheet Functions | |||
Linear Mode
