printing excel workbook

March 5, 2009 at 06:52:31
Specs: Windows XP

I have an excel 2007 workbook which contains 22 worksheets. When I use the print option to print entire workbook, it prints all of the worksheets but not in the order that they are laid out on the tabs across the bottom of the workbook. How do I change the print order of the worksheets if their tabs are already in the order I want them to be printed?

thanks!


See More: printing excel workbook

Report •


#1
March 5, 2009 at 07:56:06

If you put this code in the ThisWorkbook module of the VBA editor it will print your sheets in order.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
 For Sht = 1 To Sheets.Count
  Sheets(Sht).PrintOut
 Next
End Sub


Report •

#2
March 5, 2009 at 08:15:39

Thanks so much for your response! Now I don't have to sit and re-order my workbook pages after printing them.

Report •

Related Solutions


Ask Question