Print Order Excel XP

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

I have a workbook that has some 50 Sheets.

When I want to print the workbook, I would like to be able to define the
order in which the worksheets print, is that Possible?
 
Sub test()
Sheets(Array("Sheet3", "Sheet1")).PrintOut
End Sub

With code you can do this
 
Back
Top