Active X Control On Excel Sheet Glitch

[rameezl17]

Hi All,

I did some reading online about this and can't seem to find a direct clear answer.

I have CheckBoxes and Command Buttons (Active X Control) on multiple excel sheets. I noticed that when a user who has a different screen size/resolution than me clicks on those buttons, the buttons seem to lose their original size and the text becomes larger every time you click it. I tried playing with the properties and locking it but that doesn't seem to work. The only way around this is for the user to close out of all excel tabs they have open and pretty much restart excel application and then open up my file. Then the Active X controls work fine.

Has anyone experienced this / know a resolution to this?

Thank you for your help!

 

[Logit]

.
This won't provide an answer to your problem but ... I understand ActiveX controls (buttons) are known to cause issues.

Can you change your project to use Form Buttons instead and see if that solves the problem ?

 

[rameezl17]

Yeah, Ive been reading up on them not sure if there is another way around it. The problem is the reason I have checkboxes is because on my excel sheet I am asking Yes or No questions, so when a user clicks Yes it prompts them to a UserForm, the buttons work perfectly fine on the userform...its just on the excel sheet that it causes problems.

 

[Logit]

.
I've not heard issues with the checkboxes, etc. Only the ActiveX CommandButtons.

 

[rameezl17]

Only reason I know is because when I take out my laptop from its docking station, all the buttons /checkboxes do what I said above. Since the laptop has different resolution than the monitor I use.