Printing Entire Workbook

[Gary Thomson]

Hi All,

Is there a macro (or other method) that can be used to
print off every worksheet within a workbook, without
manually clicking on each sheet then using File -> Print??

Thanks,

Gary.
..

 

[Frank Kabel]

Hi Gary
some ways without VBA:
- in the 'File- Print' dialog choose 'Entire workbook'
- or select the first sheet, hold down the SHIFT key and select the
last sheet. Now print the selection

with VBA:

sub print_all()
dim wks as worksheet
for each wks in worksheets
wks.printout
next
end sub

Note: this will print only worksheets (does exclude Charts, etc.)

 

[Tom Ogilvy]

ActiveWorkbook.Printout