Not printing a single cell's value.

[Guest]

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

 

[Jason Morin]

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