skip printing worksheet

Posted to microsoft.public.excel.misc

Posts: n/a

skip printing worksheet

Thanks Dave O..

rw

"Dave O" wrote:

Here's a quick and dirty print macro I recorded:

Sub Print_Certain_Sheets()
Sheets(Array("Sheet1", "Sheet2", "Sheet4")).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Sheet1").Select
End Sub

Change Sheet1 Sheet2 Sheet4 to match your tab names (and add to it as
necessary), then assign this macro to a command button on your screen.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
automate printing different ranges on 1 worksheet at different tim	SteveM	Excel Discussion (Misc queries)	2	December 29th 05 03:01 PM
How do I reference data from one worksheet to another using combob	caricc	New Users to Excel	0	December 17th 05 09:58 PM
Is there a shortcut to skip down the page in a large worksheet?	Carole Drake	Excel Discussion (Misc queries)	3	December 15th 05 07:27 PM
Copy from worksheet to another x times	Union70	Excel Discussion (Misc queries)	0	March 7th 05 09:03 PM
copyright and worksheet protection	dow	Excel Discussion (Misc queries)	2	January 3rd 05 03:07 PM

All times are GMT +1. The time now is 03:06 AM.

Menu

About Us