Embedded Controls

[Chris Brunt]

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

 

[Brad]

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

 

[Chris Brunt]

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