Print macro printing sheets in wrong order

[j.farr3ll]

Hi all,

I have written the following macro to print selected sheets in my workbook:

Please Login or Register  to view this content.

In the code the sheets are in the order they appear in the workbook and this is the order I would like them to print in. However I have added some of these sheets after others and it prints as follows:

Important Information
Total Costs
Costing 3
Costing 2
Costing 1
extra Information

Is there something I can add to make it print in the order I want?

Thanks,
James

[watersev]

hi j.far3ll, try sort of that:

Please Login or Register  to view this content.

[j.farr3ll]

Hi watersev,

This does sort the ordering issue, but you have removed the following portion of code:

Please Login or Register  to view this content.

I need this to be included as the workbook will be run of multiple laptops and this allows the user to select the printer connected to the laptop.

I have tried inserting this back into the code as follows:

Please Login or Register  to view this content.

But this now asks to select the printer for each sheet (6x) is there a solution to get it to print in this order but have the select printer option only appear once?

Thanks,
James

[j.farr3ll]

The following tweak to the code worked....

Please Login or Register  to view this content.

Thanks for the help.