Print Multiple Sheets from a Listbox on a UF as one Print Job

Hi All,

I have a ListBox on a Userform that when initialised shows all the sheets listed in the ListBox.

The user then selects the appropriate sheets to print, hits the Print button (CommandButton) and the sheets are printed but as individual jobs - works a charm.

However, I would like all the sheets to print as one job.

The code I have so far is:

Please Login or Register  to view this content.

Can anyone add anything to the above to Print all sheets as one job please as despite many threads / forums visited just cant see anything that fits the bill.

Many Thanks

Craigos

Using: Office 2003, XP, SP3 at Work - Upgrading shortly Hurrah!!
Office 2010 at Home Win7

Hi John55,

Many thanks it does print out with your code, but again as single print jobs albeit one after the other but I believe I should have put in my original post to have them set up for Duplex printing, so will probably have to repost as I have seen various threads on Duplex as all sheets will only be one pagers.

Craigos