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

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.
--
Gary''s Student - gsnu200770


"Becky" wrote:

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

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") & ":"
....



--

"Gary''s Student" wrote in message
...
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.
--
Gary''s Student - gsnu200770


"Becky" wrote:

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