View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.