Hi Don

Try this:

Sub PrintHiddenSheets()
Application.ScreenUpdating = False
With Sheets("Lists")
.Visible = True
.PrintOut
.Visible = False
End With
With Sheets("Day Cost")
.Visible = True
.PrintOut
.Visible = False
End With
Application.ScreenUpdating = True
End Sub

Regards,
Per

"SSDSCA" skrev i meddelelsen
...
I have a dynamic workbook with two hidden sheets named "Lists" and "Day
Cost". The only way I can, at present, print out the "Day Cost" sheet is
to
leave it unhidden, however I would prefer to have it hidden as it has
formulas that pull the information from the other visible sheets. Can
somebody help me with a macro that would allow me to have both the "Day
Cost"
and "Lists" sheet remain hidden and only print "Day Cost" out.
--
Thanks and Regards,
Don