LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
veng
 
Posts: n/a
Default set the print area print multiple tabs

I am trying to designate the same print area on 70+ different tabs in the
same work book so that I can send them all to print at once as 70+ individual
pdf's. If I select more than one tab at a time, I dont have the option to
set the print area.

I think there are two issues:
1) How do I set the print area for all the tabs at the same time
2) How do I send each tab to print to Adobe PDF one at a time so that they
each become their own .pdf?

Is there another way to batch print different tabs?
Help Me Automate!! Please!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
How to Dynamically Set Print Area Jerry B Excel Discussion (Misc queries) 2 February 1st 05 11:21 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 07:59 PM
Changing print area Aaron Excel Discussion (Misc queries) 2 January 9th 05 05:58 PM
print a specific area within a worksheet by clicking on print? honclub Excel Worksheet Functions 1 October 29th 04 03:22 AM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"