How do I print only the hidden worksheets in a workbook?

One way:

Sub PrintHiddenWS()
Dim ws As Worksheet
Dim i As Long
Application.ScreenUpdating = False
i = 0
For Each ws In ThisWorkbook.Worksheets
With ws
If .Visible = False Then
i = i + 1
.Visible = True
.PrintOut copies:=1, collate:=True
.Visible = False
End If
End With
Next
Application.ScreenUpdating = True
If i = 0 Then
MsgBox "No hidden sheets found!"
End If
End Sub

---
HTH
Jason
Atlanta, GA

>-----Original Message-----
>
>.
>