Visible but non printable (Cell)

  • Thread starter Thread starter Wayne
  • Start date Start date
W

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I increase the number of printable characters in a cell? 1
vbcrlf question 6
Format Cell Question 1
Why full contents of cell visible only by double clicking? 1
Code to format cells on several worksheets 2
Make Object(s) Visible 4
manually selected Excel cell formatting 1
Auto-adjust row height does not work correctly 2

Back
Top