Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedded Controls
When i embed a control (eg Command Button) in a worksheet
it drastically slows down the time taken to execute commands such as print, print preview, file open. The project I am working on worked fine previously. Any ideas what is causing the slow down? regards Chris B |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedded Controls
Do you want to print the command button? There's a
boolean property called "PrintObject", that you can set to False to turn off printing. That will fix your performance issue. But I don't think it's possible to do what you're asking. HTH. -Brad -----Original Message----- When i embed a control (eg Command Button) in a worksheet it drastically slows down the time taken to execute commands such as print, print preview, file open. The project I am working on worked fine previously. Any ideas what is causing the slow down? regards Chris B . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedded Controls
I do not want to print the command button. The problem
manifests itself even on a totally blank workbook. As soon as I embed a contol (which in itself takes some time), and then for example select print preview of a range (including a range that does not include the embedded control)the print preview page takes approx 15 seconds to appear and the same delay will occur when closing the preview page. The execution of macros associated to the embedded control appears unaffected. thanks ChrisB -----Original Message----- Do you want to print the command button? There's a boolean property called "PrintObject", that you can set to False to turn off printing. That will fix your performance issue. But I don't think it's possible to do what you're asking. HTH. -Brad -----Original Message----- When i embed a control (eg Command Button) in a worksheet it drastically slows down the time taken to execute commands such as print, print preview, file open. The project I am working on worked fine previously. Any ideas what is causing the slow down? regards Chris B . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using gui controls | Excel Discussion (Misc queries) | |||
VB Controls with Macros embedded in Excel Document | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Embedded ActiveX controls | Excel Programming | |||
Limit on number of embedded controls in a workbook? | Excel Programming |