Flashing Printer Dialog

[Guest]

Hello and Help!
Excel 2003
I have a few sheets that are being compiled to a postscript file and every
sheet change causes the print progress dialog to appear and disappear. Is
there any way to make this dialog not show. I have already applied the
ScreenUpdating to False and this stops the sheets flashing, but my next
problem is the print dialog.

Any ideas.
Thanks

 

[Guest]

http://groups.google.com/group/micr...mming/msg/c59aa22ebca49415?dmode=source&hl=en

a previous posting by Stratos Malasiotis shows how.

 

[Guest]

Thanks Tom for your guidance. It worked a treat.

http://groups.google.com/group/micr...mming/msg/c59aa22ebca49415?dmode=source&hl=en

a previous posting by Stratos Malasiotis shows how.