Visible but non printable (Cell)

[Wayne]

Visible but non printable

I'm using Excel 97 and want to show the contents of a
cell on the screen, and when the work sheet is printed
the cell contents are not visible.

Any ideas?

 

[BrianB]

Use a text box and set it to not print

 

[jaf]

Hi Wayne,
You need to use the workbook.beforeprint event to change the color of the
data in the cell (white text won't print on a white background and most
printer don't have white ink) or copy the data to a new sheet and delete the
data in the cells you don't want. Then print the new sheet.