Link to home
Start Free TrialLog in
Avatar of NormanMitchell
NormanMitchell

asked on

Stop ActiveX Controls resizing randomly under Windows 7 and Excel 2010

I have ActiveX controls on a worksheet which sometimes have their properties randomly rest (e.g. width, height, font size).

This does not seem to happen with Windows XP and Excel 2007.
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NormanMitchell
NormanMitchell

ASKER

It may also be solved by setting the LockAspectRatio to true -right click the control, select format control and check the Lock Aspect Ratio check box.

This appears to have worked but it has not been in use long enough to confirm that this is a long term solution.
I am not convinced that this is the entire solution - see my own comments of 2 April 2011
Thanks Rory, it really helped me out...I was in the same boat