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 ( )

If you are talking about the "printing page 1 of 3" type dialog, then unless
you want to get into programming the windows API and subclassing Excel, then
I don't believe this can be suppressed.

Regards,
Tom Ogilvy


MrAlMackay wrote in message
...
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 ( )

There have been posts that freeze everything (windows API calls), but if
something blows up, it'll be alt-ctrl-delete time.

http://google.com/groups?threadm=zeU...ab leinet.net


MrAlMackay wrote:

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 ( )

--

Dave Peterson

If you are using the BeforePrint event, then set Cancel = True in the
procedure


Regards,
Tom Ogilvy


"Al Mackay" wrote in message
om...
Hi Tom,

The prints all come out as normal ( and the relevant dialog boxs
appear for each print, e.g. printing page 1 of 2 etc.... ) - That's
all fine.

However, when these have all finished, for some reason ( not sure
what!? ) the process is ended with the 'normal' print dialog box
appearing.

Just need this not to appear as everything has already printed by this
point.

Cheers, Al.

"Tom Ogilvy" wrote in message
...
If you are talking about the "printing page 1 of 3" type dialog, then
unless
you want to get into programming the windows API and subclassing Excel,
then
I don't believe this can be suppressed.

Regards,
Tom Ogilvy


MrAlMackay wrote in message
...
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 ( )