Can I prevent a worksheet from printing?

M

maarkr

Can I prevent a worksheet from printing?
I have 3 worksheets in the file; one of which is
calculations that I don't want to print if Entire Workbook
is selected to print.
 
J

Jim Rech

You could set the print area on the calculations sheet to one empty cell.

--
Jim Rech
Excel MVP
| Can I prevent a worksheet from printing?
| I have 3 worksheets in the file; one of which is
| calculations that I don't want to print if Entire Workbook
| is selected to print.
 
M

MTBer

Possibly try something along of using the BeforePrint event, test fo
what the activesheet is first

if activesheet="sheet1" then
ActiveWindow.SelectedSheets.PrintOut Copies:=0
end if

sorry if this doesn't work I haven't got a printer here :-
 
J

Jim Rech

sorry if this doesn't work

Apology accepted<g>.

--
Jim Rech
Excel MVP
| Possibly try something along of using the BeforePrint event, test for
| what the activesheet is first
|
| if activesheet="sheet1" then
| ActiveWindow.SelectedSheets.PrintOut Copies:=0
| end if
|
| sorry if this doesn't work I haven't got a printer here :-(
|
|
| ---
|
|
 
D

Dave Peterson

Do you have to see that sheet?

If no, how about just hiding it.

Format|sheet|Hide
 
Top