Option Buttons vs Sheet Protection?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel2003 ...

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

Thanks ... Kha
 
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)?
 
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
 
Back
Top