Posted to microsoft.public.excel.programming

gtslabs[_2_] gtslabs[_2_] is offline

external usenet poster

Posts: 15

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Printing hidden worksheets	MarcoR	Excel Discussion (Misc queries)	4	April 8th 06 09:41 PM
"With Sheets" Issue - macro on one sheet to affect hidden rows on other sheets	Punsterr	Excel Programming	3	February 21st 06 04:01 AM
Printing a hidden sheet	sungen99[_62_]	Excel Programming	5	January 27th 06 02:51 PM
Printing hidden sheets	spence[_2_]	Excel Programming	1	December 6th 03 01:09 AM
Code for Printing Hidden Sheets	Todd[_7_]	Excel Programming	2	December 3rd 03 02:12 PM

All times are GMT +1. The time now is 02:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us