I believe the sheet has to be visible but you can use a sequence like the one
below to print the sheet and it is only visible for an instant.

Sub prtSeq()
Sheets("Day Cost").Visible = True
Sheets("Day Cost").PrintOut
Sheets("Day Cost").Visible = False
End Sub



"SSDSCA" wrote:

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