Listbox Resizes after setting the IntegralHeight Property to False on others machines

[ryanparrish1986]

Hi all,

Hopefully this just a quick one.

I have created a dashboard using a number of ActiveX controls listboxes. I changed the intergalheight to False and set the zoom on an on open event. It works great and looks great on my PC. However when other colleagues opens the file on their machine and enables Macros for the sheet the Listboxes resize again.

N.B Before they enable the Macro's the Listbox sizes are correct - it is only when they enable them they resize.

Let me know your thoughts.

Many Thanks,

Ryan

[xladept]

???

Please Login or Register  to view this content.

????

[romperstomper]

ActiveX controls + worksheets = weird sizing issues generally, especially if you are not using 100% zoom. If you must use controls on worksheets, use Forms ones if you can (not MSForms) - otherwise you are going to need more code o ensure they are sized properly.

[ryanparrish1986]

thanks romperstomper do you have a sample of code I could try?

[romperstomper]

Yes - have a read of this article: http://www.experts-exchange.com/Soft...orrection.html