Uploaded November 2019 | Updated September 2026, 2 weeks ago

---

How to print only hidden worksheets in an Excel workbook automatically with VBA.
Here's the complete VBA code:

Sub PrintHiddenSheets()
Dim wksht As Worksheet
Application.ScreenUpdating = False
For Each wksht In ActiveWorkbook.Worksheets
If Not wksht.Visible Then
wksht.Visible = True
wksht.PrintPreview
wksht.Visible = False
End If
Next

Application.ScreenUpdating = False

End Sub