View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JaimeLex JaimeLex is offline
external usenet poster
 
Posts: 2
Default Print macro to exclude a cell

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...