Print Order Excel XP

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?
 
R

Ron de Bruin

Sub test()
Sheets(Array("Sheet3", "Sheet1")).PrintOut
End Sub

With code you can do this
 
Top