View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
chris brunt chris brunt is offline
external usenet poster
 
Posts: 2
Default 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
.

.