View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MrAlMackay MrAlMackay is offline
external usenet poster
 
Posts: 17
Default Stop Dialog box from appearing within macro

I have the following macro which intercepts the printing on a particular
spreadsheet as I need to set certain criteria before the sheets are printed.

Although this then calls the individual macros, which then in turn print out
the relevant sheets all ok afterwards it loads up the print dialog box still.

Is it possible to stop the print dialog box from showing?

Appreciate any help that you can offer on this.

Many Thanks, Al Mackay ( )