Printing hidden sheets with vba.
I have a sheet with a command button linked to a macro that will print
out other sheets in the workbook. Id like to have the printable sheets
hidden from view. I thought it was printing fine but today I got the
following error.
"Run-Time Error 1004"
"Printout method of worksheet failed"
My code is the following:
Worksheets("Standard").PrintOut
Can I print hidden sheets? or do I need to unhide, print, then hide
again?
Thanks
Steve
|