Hi,

I am using the dialog box
 Application.Dialogs(xlDialogPrint).Show
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!).