Printing workbook sheets in sequence
 

How do I get the workbook I've created to print in sequence as the tabs
appear at the bottom of the screen? I believe I may have reordered the
tabs/worksheets early on, and now they print out of sequence (i.e. page 5,
then 6, then 4, then 1, then 2, then 3).

Thanks.

Bremser

Printing workbook sheets in sequence
 

You might consider sorting the sheets first, either manually or
through VBA:

http://www.ozgrid.com/VBA/sort-sheets.htm


HTH,
JP

On Mar 27, 8:18*pm, Bremser wrote:
How do I get the workbook I've created to print in sequence as the tabs
appear at the bottom of the screen? *I believe I may have reordered the
tabs/worksheets early on, and now they print out of sequence (i.e. page 5,
then 6, then 4, then 1, then 2, then 3).

Thanks.

Bremser

Printing workbook sheets in sequence
 

I use this one:
http://www.cpearson.com/excel/sortws.aspx

Regards,
Ryan---

--
RyGuy


"JP" wrote:

You might consider sorting the sheets first, either manually or
through VBA:

http://www.ozgrid.com/VBA/sort-sheets.htm


HTH,
JP

On Mar 27, 8:18 pm, Bremser wrote:
How do I get the workbook I've created to print in sequence as the tabs
appear at the bottom of the screen? I believe I may have reordered the
tabs/worksheets early on, and now they print out of sequence (i.e. page 5,
then 6, then 4, then 1, then 2, then 3).

Thanks.

Bremser