jammer6_9
07-01-2009, 08:05 AM
I am trying to print selected sheets with the code below but I am having error of Sheets Class Failed. Is it because I am selecting sheets that are xlVeryHidden?
Sub PrintSheets()
Application.EnableEvents = False
Sheets(Array("Half H Sales", "Stock Level DB", "Burger Chute", "Whp Chute", "SP Chute", "Summry Chute", "KPS SP", "KPS Main", "KPS Specilaty")).PrintOut
Application.EnableEvents = True
End Sub
Sub PrintSheets()
Application.EnableEvents = False
Sheets(Array("Half H Sales", "Stock Level DB", "Burger Chute", "Whp Chute", "SP Chute", "Summry Chute", "KPS SP", "KPS Main", "KPS Specilaty")).PrintOut
Application.EnableEvents = True
End Sub