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

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
.

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
.

.