ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Activex controls on worksheet spontaneously resize (https://www.excelbanter.com/excel-programming/385588-activex-controls-worksheet-spontaneously-resize.html)

Russell Reid

Activex controls on worksheet spontaneously resize
 
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?
--
Russell Reid

[email protected]

Activex controls on worksheet spontaneously resize
 
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



All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com