Canceling a Print Job

**EdWoods** · 11-14-2013, 06:46 PM

Hi,

I am using the dialog box

Please Login or Register  to view this content.

to start a print job so I can select the printer I want to use.

The macro runs printouts from three seperate worksheets, but I only show the dialog box once, as this sets the printer for the rest of the printouts.

If I select cancel from the above dialog box, it stops the print of the first page, but not subsequent pages.

What can I put in after the dialog box to exit the sub and not print the rest of the pages?

Thanks in advance (yet again!).

**shg** · 11-14-2013, 07:24 PM

Need to see the rest of the code.

**EdWoods** · 11-14-2013, 07:29 PM

Originally Posted by shg

Need to see the rest of the code.

Please Login or Register  to view this content.

**shg** · 11-14-2013, 08:02 PM

The Show returns False if all you do is change (or not change) the printer (rather than print). I don't know of a way to distinguish between that and the user pressing Cancel, which also returns False. Perhaps someone else does.

In the alternative, you could use a MsgBox to ask the user whether to proceed with printing.