Printing entire workbook - landscape and portrait pages

  • Thread starter Thread starter CrazyTexan
  • Start date Start date
C

CrazyTexan

Is there any way to print an entire workbook at once... if some of th
pages are to be printed landscape, while others are potrait? I jus
combined 20 different but related files into one workbook, but now I'
having trouble printing the whole batch. I really don't want to prin
each one one at a time, that defeats the whole purpose of combinin
them, which was to minimize repetative tasks such as this.

Thanks!
J
 
Hi
try recording a macro while printing the pages one by one (and changing
the orientation while doing this). After this use the recorded macro
 
J,

You can use File - Page setup to specify portrait or landscape on a sheet by
sheet basis. You can do several at a time by using the Ctrl and/or Shift
keys as you click the sheet tabs.
 
if each *file* is a separate worksheet, hold CTRL while selecting each
worksheet tab you want to print. Then hit the print button or go to
FILE|PRINT. It will print each page as it is set-up. Be sure after
printing that you right click on one of the grouped worksheets and choose
UNGROUP SHEETS... otherwise you may inadvertanatly make changes to every
grouped worksheet at once.

If you want a macro... John walkenbach has a batch print macro that I use
and it works very well. check out his website www.j-walk.com/ss or if you
want I can post the code I have.. although it is slightly modified.

HTH,
 
Back
Top