asked on

How can I stop controls in Excel 2007 from changing size when clicked?

Several Excel worksheets I developed in Excel 2003, which worked fine for years in that version, are exhibiting bizarre behaviour in Excel 2007. When I click a control I've added to the worksheet -- whether a form control or and ActiveX -- they automatically resize themselves -- either shriking or growing as shown in the attachments. Does anyone know why this is happening and how to stop it?

Thank you!

Control-Sizing-Clipping.jpg
Control-Sizing-Clipping-2.jpg

zorvek (Kevin Jones)

I would expect (and have often seen) that behavior from those nasty Active X controls but NOT from a Forms control. Are you absolutely certain the Forms controls are doing that as well? I will bet good money they are not ;-)

Kevin

zorvek (Kevin Jones)

As far as Active X controls, don't use them. Not only do they behave erratically, they are a primary cause of workbook corruption - right behind the internal formatting tables.

The only workaround besides Forms controls is to add your own code to constantly repair the Active X controls as they morph into what you don't want.

Kevin

Yaroslavl

ASKER

Kevin -

Thank you. Did you find this to be the case with Excel 2003? I never once saw the behaviour in 2003.

zorvek (Kevin Jones)

Yes. Frequently. I also witnessed font size changes and workbook corruption. I decided to never use them again. Too risky.

Kevin

Yaroslavl

ASKER

Interesting, I never had issues until coverting to 2007.

Did you have issues with VBA forms -- in either 2003 or 2007? I did have issues with VBA forms causing workbook corruption in 2000, but not in 2003. (I haven't so far in 2007, but it's too early to say.)

ASKER CERTIFIED SOLUTION

zorvek (Kevin Jones)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Yaroslavl

ASKER

Thank you for your assistance. I appreciate it!

Bob

Yaroslavl

ASKER

A for Kevin, F for Microsoft. :)