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