Prevent Printing of Specific Cells

[Guest]

Hi, folks. I'm looking for a way to format a cell so that the cell(s) will
_display_ on the worksheet, but not _print_ when the worksheet is printed.

I'm working on a sales worksheet. Some data on the worksheet, such as the
"dealer cost", need to be visible to the salesman and used in some
calculations, but if the salesman prints the worksheet, I don't want those
items to print.

Any thoughts?

Thanks.

 

[Paul B]

Ken, have a look here for a way to do it,

http://www.rondebruin.nl/print.htm#Hide
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Hmmm, I must not be doing it quite right.

I copied the appropriate sections of the code and ended up with

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.Rows("31:31").EntireRow.Hidden = True
.PrintOut
.Rows("31:31").EntireRow.Hidden = False
End With
End Sub

because I wanted to suppress printing for the cells in Row 31. Now it
prints the page twice; once with row 31 suppressed, and once with row 31
visible.

Any idea what I did wrong? Thanks.

 

[Ron de Bruin]

Read the code Ken

I use this to cancel the normal print
Cancel = True

 

[Bill (Unique as my name)]

The Stupid Way:

Link conditional formatting to a cell value to change the font and
background color to what ever color you decide. Change the value of
the cell in code or manually before printing. After printing, change
the value back.

 

[Guest]

Aha! Thanks. I appreciate the help.

Read the code Ken

I use this to cancel the normal print
Cancel = True