View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.