Printing tabs all at once

[excel-lent13]

Hey guys,

I have a file with a lot of tabs. Each tab has it's own page numbering setting. Is there a way I can select all tabs and print these documents without have the page numbering grouped together. Currently, when I select all tabs and print, it renumbers the pages. If tab 1 had 1 page and tab 2 2 pages, then it would number the whole print job 1, 2, 3...etc. I want them to print individual page numbering per tab. Thanks in advance!

[JBeaucaire]

Here's a macro that will print each worksheet in a workbook as it's own print job.

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.