Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing not within the cells | Excel Discussion (Misc queries) | |||
Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions | |||
exporting single cells to Word | Excel Discussion (Misc queries) | |||
Formatting cells for printing | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) |