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.
NormanMitchellAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
ActiveX controls on worksheets are notorious for this kind of behaviour in all versions of Excel. It's often related to the zoom of the window not being set to 100% but can be caused by other things. As a general rule I would recommend using Forms controls instead if you can, or use code to reset the sizes when the sheet is activated if it's a real issue.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NormanMitchellAuthor Commented:
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.
0
NormanMitchellAuthor Commented:
I am not convinced that this is the entire solution - see my own comments of 2 April 2011
0
RayneCommented:
Thanks Rory, it really helped me out...I was in the same boat
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows XP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.