Option Buttons vs Sheet Protection?

[Guest]

Excel2003 ...

How do I "Protect" a WorkSheet & "Allow" Checking of OptionsButtons?

Thanks ... Kha

 

[Dave Peterson]

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

 

[Guest]

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