Option Buttons in group get unselected in protected sheet

[MukulPurohit]

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 so I set the value off $I$6 to 2. (This makes the second option box selected)
Then I mark Cell $I$6 as locked as I do not want user to be able to change the option selection.

When I mark the sheet as protected and I click on 1st Option Button I get an expected error message -

But when I click OK on this both the option boxes get unselected and the linked cell value is still showing two.
Expected behavior is that the second option should still be shown as selected ... but it is not !!!

Can you please help me with this?
Regards
Mukul

 

[jkpieterse]

This is a cross post, you are supposed to add a link to any place where you posted this same question.

 

[Jaafar Tribak]

If you can use vba then you could assign the following macro to both optionbuttons :

Place in a new Standard Module:

Sub Opt_Click()
    ActiveSheet.OptionButtons(Application.Caller).Value = xlOn
End Sub

 

[MukulPurohit]

Link to same question I posted on Microsoft Tech Community