Activex controls on worksheet spontaneously resize

G

Guest

Has anyone else had an issue where the activex controls on a worksheet resize
themselves after a print or other operation? This only began to happen after
we moved to Excel 2007. Also, operation of some controls seems to be much
slower in 2007 than in 2003. All machines are minimum P4 2.0 with 1Gb Ram.
All code is written in VBA.

Is there a solution for this problem?
 
K

kemal

Hi Russell

1.Right click on control
Click "Format Control"
Click "Properties" to check the option if anything changed.

2.Which control triggers what code that seems to be
slower than 2003.
Pls post the code.People may have both 03 and 07

rgds
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top