Not printing a single cell's value.
 

I may be asking this question in the wrong forum, but the "printing group"
does not seem very active

Is it possible to have a cell's value shown on the screen but when the page
is printed the cell would appear blank. It is a value that users of the sheet
need to see but not those who would just be viewing it on paper. Thank you Jay

You can run a macro to hide the cell's contents, print
out the sheet, then unhide the cell's contents.

Something like:

Sub test()
'Change A1 to correct cell
Application.ScreenUpdating = False
With ActiveSheet
.[A1].NumberFormat = ";;;"
.PrintOut
.[A1].NumberFormat = "General"
End With
Application.ScreenUpdating = True
End Sub

---
HTH
Jason
Atlanta, GA

-----Original Message-----
I may be asking this question in the wrong forum, but
the "printing group"
does not seem very active

Is it possible to have a cell's value shown on the
screen but when the page
is printed the cell would appear blank. It is a value
that users of the sheet
need to see but not those who would just be viewing it
on paper. Thank you Jay
.