Supressing a cell when printing

  • Thread starter Thread starter slac65
  • Start date Start date
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.
 
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..
 
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.
 
It does not work all the time: page breaks within the hidden zone are
"printed"
Another solution?

AG
 
Back
Top