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 Unprotect the sheet, right-click the cell the option buttons are attached to and press control+1. Click the Protection tab and uncheck locked. Now protect the sheet again.
Thank you for your reply ... it seems it still does not work..
I tried marking all the cells in the excel as Unlocked except for linked cell.( I do not want user to be able to change the option selection.).. I still observe the same behavior!!!
Regards
Mukul