PDA

View Full Version : Solved: Printing Selected xlVeryHiddenSheets



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

Bob Phillips
07-01-2009, 08:14 AM
Probably, so make them visible then hide them afterwards.

jammer6_9
07-01-2009, 08:54 AM
That's what I've just did which work just fine. I just could tried it first before asking :help ... Thanks for the response XLD...


Probably, so make them visible then hide them afterwards.