software

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 quot;hidingquot; 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
gt;File gt;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

quot;Dave Oquot; wrote:

gt; You can group the sheets you want to print by pressing the CTRL button
gt; and left-clicking the tabs at the bottom of the screen. Then click
gt; gt;File gt;Print, select Active Sheets from the window, and press OK.
gt;
gt; Remember to ungroup the tabs by right clicking a grouped tab name and
gt; selecting Ungroup Sheets. When tabs are grouped, a change made to one
gt; tab will reflect in ALL the grouped sheets, which can work for you or
gt; (bitter voice of experience talking) delete data.
gt;
gt;

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

Sub Print_Certain_Sheets()
Sheets(Array(quot;Sheet1quot;, quot;Sheet2quot;, quot;Sheet4quot;)).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets(quot;Sheet1quot;).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

quot;Dave Oquot; wrote:

gt; Here's a quick and dirty print macro I recorded:
gt;
gt; Sub Print_Certain_Sheets()
gt; Sheets(Array(quot;Sheet1quot;, quot;Sheet2quot;, quot;Sheet4quot;)).Select
gt; ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
gt; Sheets(quot;Sheet1quot;).Select
gt; End Sub
gt;
gt; Change Sheet1 Sheet2 Sheet4 to match your tab names (and add to it as
gt; necessary), then assign this macro to a command button on your screen.
gt;
gt;