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