Forum Discussion
Option buttons in protected sheet get unselected
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
MukulPurohit If you do not want the users to change the option, why are they there? I suggest to "just" use a data validation drop-down in a cell with the two choices that are currently shown on the option buttons. For that protection works as expected.
It is our business requirement. Basically in our case, we are creating a application form which user partially fills online and then we give them an excel to fill it offline.
This Excel will contain some prefilled data which user has filled online and which will not be editable in the excel. For Example - certain using option buttons like Gender - Male, Female, Transgender. (These fields are shown using option buttons in online form).
We want to make sure these prefilled fields look as similar as online form and thus we want to render option buttons as well which are pre selected and non editable.
Also we can not use macros as we want to keep this Excel as static as possible.
So is there a way we can achieve this with option buttons ? As changing them to list / dropdown will give different UI look and feel
