The Incredible Growing VBA Button!

[Doug Blackwell]

I created a user interface in an Excel worksheet. There were a few Active X buttons which loaded data and created reports. It worked fine on my computer. However on someone else's laptop the buttons were larger that they should be. I don't think it was screen resolution as the rest of the sheet was normal. THEN... Something really weird happened. As the person used the application... THE BUTTONS GOT LARGER AND LARGER! It was like watching a horror movie. There was nothing in the VBA code that should affect size.

If anyone has any clue why the buttons would grow larger I be grateful!

Thanks,
D

 

[Sektor]

In button properties set "Don't move or size with cells"

 

[Ruddles]

I designed a worksheet with a couple of ActiveX listboxes which behaved perfectly on my machine but on about half of the end users' machines they shrunk slightly every time the worksheet was opened. (The users didn't actually report this until they were so small that they became unusable!)

I ended up resizing and repositioning them in the Workbook_Open event.

 

[Balrog]

This solved my problem in Excel 2003/2010:

Controls on an Excel 2003 or Excel 2010 worksheet change size after you change the screen resolution

 

[Ruddles]

Mine were changing size every time the workbook was opened - the screen resolution wasn't changing.