View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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

.