• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

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
0
Yaroslavl
Asked:
Yaroslavl
  • 4
  • 4
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
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
0
 
zorvek (Kevin Jones)ConsultantCommented:
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
0
 
YaroslavlAuthor Commented:
Kevin -

Thank you.  Did you find this to be the case with Excel 2003?  I never once saw the behaviour in 2003.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
zorvek (Kevin Jones)ConsultantCommented:
Yes. Frequently. I also witnessed font size changes and workbook corruption. I decided to never use them again. Too risky.

Kevin
0
 
YaroslavlAuthor Commented:
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.)
0
 
zorvek (Kevin Jones)ConsultantCommented:
Not with VBA forms. That's actually where ActiveX forms are designed to be used, not on the worksheet. Forms controls were created for the worksheet but somehow the ActiveX controls made it there too. It's made for a lot of frustrated developers.

All my comments above are regarding ActiveX controls on a worksheet. From the pain and suffering I have experienced in the past I will NEVER use them again unless I absolutely have to. I have built my own controls out of shapes versus using ActiveX.

Kevin
0
 
YaroslavlAuthor Commented:
Thank you for your assistance.  I appreciate it!

Bob
0
 
YaroslavlAuthor Commented:
A for Kevin, F for Microsoft.  :)
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now