Tracking Changes in Excel

[Becky]

Is there a way that I can change the default on "Highlight Changes"

When making revisions in a cell, I would like the changes to be noted either
by shading the cell or changing the font color, making it easier to see the
changes being made.

 

[Gary''s Student]

Let's change the background color of any cell you change. Enter the
following macro in the worksheet code area:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Interior.ColorIndex = 6
Application.EnableEvents = True
End Sub

Any cell you change will turn yellow.

 

[PCLIVE]

This is a good idea...but it won't allow the worksheet owner approve the
changes. Anything the owner changes will either turn or remain yellow.
Also, it doesn't make a note of who the changes were made by.

You could possibly incorporate this to capture the user who made the
changes. That still doesn't fix the issue of needing the cells to be reset
when approved.

Target.AddComment
Target.Comment.Visible = False
Target.Comment.Text Text:=Environ("username") & ":"
....



--