Macro that Prints

[JVID]

I have a workbook (excel 2007) that has many worksheets in it. I print different variations of them (usually to PDF). Is there a script that works off a sheet where I can tell it what worksheets to print together and what to call it.

Thanks for all your help in the past and going foward.

JV

 

[ajay_gajree]

Try this

Printing multiple pages with different layouts using Excel | Chandoo.org - Learn Microsoft Excel Online

Always found it useful!

 

[JVID]

Thanks! This, in theory, is everything I want. However I have massive amounts of worksheets (over 1000). Let's see if it works!

JV

 

[JVID]

I am having issues installing it. I tried running the macro from VBA once I copied it. Is it supposed to make a "index" of all my worksheets?

Try this

Printing multiple pages with different layouts using Excel | Chandoo.org - Learn Microsoft Excel Online

Always found it useful!