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

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.

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.

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

"Dave O" wrote:

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.

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.

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.

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.