Suppressing or turning off the Printing dialog
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.
|