skip printing worksheet

R

rw

I have a workbook with many worksheets - When I print the entire workbook, I
would like to not print a specific worksheet.

I know you can do this by "hiding" the worksheet, is there another way?

thanks
rw
 
D

Dave O

You can group the sheets you want to print by pressing the CTRL button
and left-clicking the tabs at the bottom of the screen. Then click
File >Print, select Active Sheets from the window, and press OK.
Click to expand...

Remember to ungroup the tabs by right clicking a grouped tab name and
selecting Ungroup Sheets. When tabs are grouped, a change made to one
tab will reflect in ALL the grouped sheets, which can work for you or
(bitter voice of experience talking) delete data.
 
R

rw

Thanks Dave O,

I knew this too - howver, there are many worksheets and only 1 I don't want
to print,. Alos I need to show this to others hwa are.. let's say not too
computer literate. Maybe I could create my own print button with a Macro to
select and print the worksheets.
Would this work? probably -- Any other ideas....

There's no way to mark the sheet as no print .. ? right now I set the
print area to 1 empty cell , which creates a blank page .. but makes calls to
me about missing info go away..

Thanks
again.

rw
 
D

Dave O

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.
 
Top