View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary
 
Posts: n/a
Default font change when editing

I have this I can place on the sheet module to change font when editing. Is
there a way to put this into a macro so I can enter this into the sheet
automatically each time I am emailed a new version of the workbook?

Thanks.


Private Sub Worksheet_Change(ByVal Target As Range)
Target.Cells.Interior.ColorIndex = 4
End Sub