ExcelBanter - Printing Problem

Is there a way to automate this?

"John Mansfield" wrote:

Hi,

If you select all of the worksheet tabs at once (hold down
the shift key and press each worksheet tab that you want
to print) and then run through your print routine, the
pages should print in order and the page numbers should be
sequential.

John Mansfield
pdbook.com

-----Original Message-----
Hey all...

I have copied worksheets from several workbooks into one
workbook. When trying
to print the newly created workbook it prints out of
order. Any advice?
.