View Single Post
  #1   Report Post  
Julie
 
Posts: n/a
Default How to protect Option button in worksheet

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 ControlProtectionLocked 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