| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option Buttons vs Sheet Protection?
Excel2003 ...
How do I "Protect" a WorkSheet & "Allow" Checking of OptionsButtons? Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Option Buttons vs Sheet Protection?
I put a couple of optionbuttons from the Control toolbox toolbar on a worksheet
and protected that worksheet. I could check those optionbuttons. Any chance you used a linkedcell and then locked that cell (on that protected worksheet)? Ken wrote: Excel2003 ... How do I "Protect" a WorkSheet & "Allow" Checking of OptionsButtons? Thanks ... Kha -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Option Buttons vs Sheet Protection?
Yes ... That is exactly what I did ... "Locked Linked Cell" ... I am all set
now ... Previously, I "unlocked" the cell the ObjectButton was in ... then I unlocked the OptionButton Protection ... then I set Protection to Allow Editing Objects ... then I turned to this board ... This is such a GREAT BOARD ... Thank you for supporting it ... Kha "Dave Peterson" wrote: I put a couple of optionbuttons from the Control toolbox toolbar on a worksheet and protected that worksheet. I could check those optionbuttons. Any chance you used a linkedcell and then locked that cell (on that protected worksheet)? Ken wrote: Excel2003 ... How do I "Protect" a WorkSheet & "Allow" Checking of OptionsButtons? Thanks ... Kha -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forms Option Buttons(Can be right mouse selected when sheet is loc | Excel Discussion (Misc queries) | |||
| option buttons | Excel Worksheet Functions | |||
| Option Buttons | Excel Discussion (Misc queries) | |||
| Using 'Option Buttons' | Excel Discussion (Misc queries) | |||
| Option Buttons move after placing on sheet | Excel Worksheet Functions | |||
Linear Mode
