B
Brad
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
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