Excel 2003 -

Workbook has many sheets - all but three are hidden.

"shtInput" is always visible

What I want to do is to control which sheet get printed first and I want the
sheet that has a sheet name ending in "v" print first and the other sheet to
print second. There will always be only one visible sheet that has a sheet
name ending if "v".

Below is the working macro that I would like to add to. Any help would be
greatly appreciated.




Sub Print_pages()
Dim sht As Worksheet
shtAgent.Visible = False
For Each sht In Worksheets
If sht.Name < shtInput.Name And sht.Visible = True Then
sht.PrintOut
End If
Next
End Sub