Forum Discussion
Option buttons in protected sheet get unselected
Hello Team, I have created one group box and added two Option Buttons (form Control) inside it. And I have Linked the option buttons to cell $I$6. I want to show 2nd option button as selected and s...
MukulPurohit One possible workaround to achieve what you're asking for is to insert a text box overtop of the group box and option buttons, then format the text box with "No fill" and "No line". When protecting the worksheet, make sure the option to "Edit objects" is unchecked, which will make the text box, as well as the objects beneath it, inaccessible to the user.
Text Box Overlay
Note: this can also be done by inserting a shape (rectangle), but you would need to format the shape with "Solid fill" and 100% Transparency.