Supressing a cell when printing

S

slac65

I have a range of cells that contain text. My question is
how do I display the text on the spreadsheet but supress
it when printing.
 
P

Peo Sjoblom

You could use a macro that hides the particular rows/columns in a before
print macro and then
unhide them again

Rows("3:3").EntireRow.Hidden = True
..PrintOut Copies:=1
Rows("3:3").EntireRow.Hidden = False

the above will hide row number 3, print
then unhide..
 
K

Ken Wright

Or if you don't want to touch the structure of the sheet you could just have the
macro turn the font for those cells white, then print then turn them back to
automatic or whatever colour they were.
 
A

AG

It does not work all the time: page breaks within the hidden zone are
"printed"
Another solution?

AG
 
K

Ken Wright

So did you try Peo's suggestion of hiding the rows between page breaks with
code.
 
Top