How hide cells when print out?
 

Hi,

I have a range of cells I don't want to be printed. Today, I hide them with
same colour for font and background and I thought it worked well - until
todays discovery:

Choosing Black/White printout, they are beeing printed!

Therefore, have any of you an idéa how to "veryhidden" the cells, never to
be printed?

I can't temporary delete the cells, nor hide the rows or columns. I have
some code pointing at the cells, so I can't just move them without a lot of
work.

Kind regards
/Gunnar

How hide cells when print out?
 

Hi
hiding should be no problem for your code :-)
See ron's site for some prining code:
http://www.rondebruin.nl/print.htm#Hide

-----Original Message-----
Hi,

I have a range of cells I don't want to be printed.
Today, I hide them with
same colour for font and background and I thought it
worked well - until
todays discovery:

Choosing Black/White printout, they are beeing printed!

Therefore, have any of you an idéa how to "veryhidden"
the cells, never to
be printed?

I can't temporary delete the cells, nor hide the rows or
columns. I have
some code pointing at the cells, so I can't just move
them without a lot of
work.

Kind regards
/Gunnar



.

How hide cells when print out?
 

format the cells as

;;;

--
Regards,
Tom Ogilvy

"Gunnar Johansson" wrote in message
...
Hi,

I have a range of cells I don't want to be printed. Today, I hide them
with
same colour for font and background and I thought it worked well - until
todays discovery:

Choosing Black/White printout, they are beeing printed!

Therefore, have any of you an idéa how to "veryhidden" the cells, never to
be printed?

I can't temporary delete the cells, nor hide the rows or columns. I have
some code pointing at the cells, so I can't just move them without a lot
of
work.

Kind regards
/Gunnar