Problem with options button dimensions

[chobanne]

Can someone help me with this problem. I dont know if there is setting for this in excell

I have one active X controls OptionButton which i often use. Everytime i click it, it change its size. It constantly decreasing. Afer several clicks it almost dissapear. Its frustrating for me, can someone please help me how to fix the size of that button
I m using microsoft office 2016.

Thank you

 

[jkpieterse]

Perhaps it helps to delete the option button and add a new one back.

 

[chobanne]

is it possible to do something without deleting

 

[jkpieterse]

Is your window zoom set to something other than 100%? Zoom sizes other than 100 can cause this to happen.
ActiveX controls are sometimes unreliable and you've just encountered behavior they regularly show.

 

[chobanne]

it is set to 100

 

[jkpieterse]

In that case I think you can't do much more than remove the control and add it back. With no warranty it'll keep behaving itself.
You could record a macro while you size and place it where it should go and have the Workbook_Open event call that macro?

 

[chobanne]

If that work that will be great but i don t know how to make that macro and where to put it

 

[jkpieterse]

I advised to record the macro, not to write it
A recorded macro will be inserted in a normal module. The ThisWorkbook module is where you add the Workbook_Open event. Plenty of explainer videos on youtube on how to do that I imagine.

 

[jkpieterse]

See: Automatically run a macro when opening a workbook - Microsoft Support