Printing Workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How does one define tht print order of an entire workbook?

I have five six page worksheets and a summary worksheet.
When I ask excel to print the entire workbook I get
worksheets 1 then 2 the 3 then the summary then 4 and
finally 5.
 
This macro does a printpreview of all based on where the sheet is.
sort worksheet in order that you want by click and hold sheet tab>drag to
where desired.

Sub printwb()
Sheets.Select
ActiveWorkbook.PrintPreview
Sheets("sheet1").Select
End Sub

or do this to not move

Sub printinorder()
With ActiveWorkbook
..Sheets("sheet1").PrintPreview
..Sheets("sheet5").PrintPreview
..Sheets("sheet3").PrintPreview
End With
End Sub
 
Back
Top