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.

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.

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.

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.

You could only hide it by using the wiindows API to freeze the screen.
Search the google archives for the code.

--
Regards,
Tom Ogilvy

"Jeff Lefebvre" wrote in message
...
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.