How to protect Option button in worksheet

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

Guest

Good day everybody,

I use Excel to create a form for user to fill up.
There is a set of Option buttons which is for my own use where I want to
protect them from be select/change by user.
I have set the Format Control>Protection>Locked ticked. But after protect
worksheet, I can still select/change the Option buttons.
Can someone tell me how to protect the Option buttons?

Thanks in advance.

Have a nice day & Happy New Year.

Best regards,
Julie
 
Hi Julie-

Your option buttons should be protected. While the user
may be able to click the option buttons, they cannot alter
them and change the cell link. After 1 or 2 clicks, the
user should receive a protection message.

HTH
Jason
Atlanta, GA
 
Thanks Jason for your response.
However, the option buttons do change when they are click eventhough the
worksheet is protected.
Did I miss anything? I am using Excel 2002 (10.6501.6626) SP3.
 

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

How to protect option button? 1
How do you insert & delete rows in a protected worksheet? 1
Protect Sheet - But have button to add more lines 1
when I protect a worksheet, user cannot use check boxes 4
Simple Worksheet Protection 2
Insert/ delete row in protected worksheet 7
Using solver function in a locked (protected) worksheet 2
How to protect option button? 4

Back
Top