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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Protection? 2
Excel2003 vs 2007 ... :( 2
SUM ... Numbers, Nulls "", & Div/0 5
Searching Post? 5
Column vs Row Size Ratio? 3
Symbol = Character Code 25BA 1
Delete an Add-In? 3
WorkSheet Cell Precedents? 4

Back
Top