All Pages Don't Print

[pclark]

I have an excel doc that has 4 pages. When I print the
doc, the only page that prints is the page that is
currently open. I have to click each tab at the bottom of
the page to print each page. Is there a way to set the
doc so when I click print, all pages print?

 

[Andy B]

Hi

Group the sheets before you hit print (right click on one of the tabs and
click 'Select all sheets'
Don't forget to ungroup them afterwards, though.

Andy

 

[Ron de Bruin]

Another way is to right click on the file in Windows explorer
And click on Print

 

[Don Guillett]

Sub printemall()
ActiveWorkbook.Sheets.Printout 'Preview
End Sub

 

[RagDyer]

<File> <Print>
Under "PrintWhat"
Check "EntireWorkbook"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================