Couple of ways:
<File <Print
And at the bottom, under "Print What",
Place a check in "Entire Workbook".
*OR*
Click in first tab of the WB, hold <Shift, click in last tab,
And while *all* sheets are selected, click <Print.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"dangerfield" wrote in message
...
frequently need to print whole excel file w multiple tabs and can't find
how to set this up... would appreciate a headsup how to... thankyou
thankyou!
|