Option Buttons vs Sheet Protection?
 

Excel2003 ...

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

Thanks ... Kha

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

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