sorry, i have no idea. I 've tried
Application.DisplayAlerts = False
Application.Screenupdating=false
but to no avail.

Sebastienm

"Jeff Lefebvre" wrote:

Thanks Sebastien.

I am using the PrintOut method, but don't see any options to suppress the
"Printing..." dialog box.

"sebastienm" wrote:

Hi Jeff,
Are you using the Dialogs to priont within vba? eg:
application.dialogs(xlDialogPrint....).Show
You can also use the PrintOut method:
Dim Wkb as Workbook, Wsh as Worksheet, Rg As Range
Wkb.PrintOut
Wsh.PrintOut
Rg.PrintOut
The PrintOut has parameters .. check in the Online-help.
Regards,
Sebastien

"Jeff Lefebvre" wrote:

How can I not show the "Printing" dialog box that comes up when I print from
a VBA routine.

I've had problems when users accidently click the Cancel button and it stops
the code from executing. I figure not showing the dialog box is the best way
to avoid this.