And he thinks of a nice way to attack things - I was thinking of attacking it
through the _BeforePrint() process, as opposed to "make the change ... do the
print ... reverse the change" which is not a 100% satisfactory solution -
could be if you could detect when the printing has finished/file has been
sent to the spooler.


"Dave Peterson" wrote:

Ron does nice work!

JaimeLex wrote:

Thank you so much! That was perfect. It worked to a "T".

"Dave Peterson" wrote:

I'd start by looking at Ron de Bruin's site:
http://www.rondebruin.nl/print.htm#Hide

JaimeLex wrote:

Hi,

I'm completely new to macros and having a tough time getting this to work.
I've got an IF statement in a merged cell of my worksheet (Cell B10). Text
appears in the cell if a certain condition is met.

I want to create a macro for this workbook only that will change the font in
cell B10 to white prior to printing and back to the red I selected after
printing. Is there a way for this to run automatically when a user prints
this workbook?

Any help would be great as this is my first macro and I'm not sure where to
start...

--

Dave Peterson


--

Dave Peterson