Don't print a specific cell
 

Is there a function or any way to specify a certain cell within a print area
to NOT print?

Don't print a specific cell
 

Hi

You could colour the font the same colour as the cell background. I guess
this could also be done using a macro which could run before printing.

Andy.

"Mike" wrote in message
...
Is there a function or any way to specify a certain cell within a print
area
to NOT print?

Don't print a specific cell
 

But then I can't see what's in the cell, which defeats the purpose.

"Andy" wrote:

Hi

You could colour the font the same colour as the cell background. I guess
this could also be done using a macro which could run before printing.

Andy.

"Mike" wrote in message
...
Is there a function or any way to specify a certain cell within a print
area
to NOT print?

Don't print a specific cell
 

Well, record a macro while you colour the font white, print the document and
then colour the font back?
I've just done that and it took me 30 seconds and it works great!

Andy.

"Mike" wrote in message
...
But then I can't see what's in the cell, which defeats the purpose.

"Andy" wrote:

Hi

You could colour the font the same colour as the cell background. I guess
this could also be done using a macro which could run before printing.

Andy.

"Mike" wrote in message
...
Is there a function or any way to specify a certain cell within a print
area
to NOT print?

Don't print a specific cell
 

What Andy is saying is simply make the text the same color as the
background, print the document, then change the color back. Simply
hide it for printing purposes.

Don't print a specific cell
 

I understand that, but it's going around the issue. I need to make this as
user friendly as possible, and don't want to incorporate vb code, because
some people will choose to disable it. Thought there might be a function or
something that would handle this. Guess not. Thanks anyways.

"ChuckF" wrote:

What Andy is saying is simply make the text the same color as the
background, print the document, then change the color back. Simply
hide it for printing purposes.