font change while editing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.


enter the following code in the module of the sheet in question. The cells
are colored green after you edit them.

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Cells.Interior.ColorIndex = 4
End Sub
 
Gary said:
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.


enter the following code in the module of the sheet in question. The
cells are colored green after you edit them.

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

This sounds like an Excel question. You'd do better to post it in one
of the newsgroups devoted to Excel, rather than this one, which is
devoted to forms in Microsoft Access, the database program.
 
Back
Top