CODEWITHSUNDEEP
excelvbabuttonsizeactivex
JFerro
JFerro

Reputation: 3433

excel active X buttons getting bigger every action

This is a question with the same title as here: VBA Active-X buttons getting bigger with every action

I guess the problem is the same. The question is nevertheless from 2014!!! and it does not really have an answer.

In my case the buttons were NOT created programatically, but just clicking in insert activeX control, button, and then click for writing the VBA behind.

In order to better illustrate the problem I made a video with my handy: https://www.youtube.com/watch?v=hBiu2FfRxQU

IN the video you can see how every time a button is clicked it gets bigger.

as note aside I have to say that this only happens when I connect remotely with my computer via a think client. Nevertheless both screens are the same (i.e. have the same resolution).

This is of course very annoying because it makes almost impossible to use home working since connecting to my excel at work makes all the buttons go crazy in size.

Upvotes: 0

Views: 466

Answers (2)

Shekhar Nalawade
Shekhar Nalawade

Reputation: 127

I had faced this issue today itself. And found very strange solution to this problem.

I just tried to resize the button where I was facing the issue and it was solved.

Hope this works with you.

Upvotes: 0

JFerro
JFerro

Reputation: 3433

As @TimStack and @jvdv has pointed out this is a known issue of Microsoft, i.e. a BUG, there since many years. Hence there is no solution but workarounds. So stay away from controlX if you don't want to get surprises.

Upvotes: 1

Related Questions