M
Mike
Is there a function or any way to specify a certain cell within a print area
to NOT print?
to NOT print?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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.
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.
M
Mike
But then I can't see what's in the cell, which defeats the purpose.
G
Guest
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.
then colour the font back?
I've just done that and it took me 30 seconds and it works great!
Andy.
C
ChuckF
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.
background, print the document, then change the color back. Simply
hide it for printing purposes.
M
Mike
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.
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.