View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gtslabs[_2_] gtslabs[_2_] is offline
external usenet poster
 
Posts: 15
Default 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