Printing workbook sheets in sequence

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bremser - 28 Mar 2008 01:18 GMT

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

Reply to this Message

JP - 28 Mar 2008 03:21 GMT

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

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

HTH,
JP

> 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
[quoted text clipped - 4 lines]
>
> Bremser

Reply to this Message

ryguy7272 - 28 Mar 2008 20:39 GMT

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

Regards,
Ryan---

Signature

RyGuy

> You might consider sorting the sheets first, either manually or
> through VBA:
[quoted text clipped - 12 lines]
> >
> > Bremser

Reply to this Message