Printing order

I have wrote this in Excel my problem is I wanted these diffrent sheets to print in sequence, however when they print "test1" prints then "test3" then back to "test2". Anyone know how to sequence the order of printing so test1, test2, test3 sheets will print in this order?

Private Sub CommandButton1_Click()
If optAll.Value = True Then
Sheets("test1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("test2").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("test3").Select

Have you tried using:


Worksheets("Test1").PrintOut
Worksheets("Test2").PrintOut
Worksheets("Test3").PrintOut


Or doesn't it make a difference?

Have you tried using:


Worksheets("Test1").PrintOut
Worksheets("Test2").PrintOut
Worksheets("Test3").PrintOut


Or doesn't it make a difference?


Gave it a try but no luck.
Thank you,