Excel Tracking Changes

[Iona]

Hello All Experts,

I have an excel 2003 workbook with multiple tabs that are updated weekly.
Currently, the users highlight their weekly changes and once I update the
master worksheet I unhighlight these cells. Is there an easier way to track
changes? Please keep in mind that the worksheet the users are updating is
housed on an older version of sharepoint. So we are unable to share a
workbook.

Thank you for any insight and have a nice weekend!

Can I create a summary tab for the weekly updates that automatically updates
when someone updates a cell in the seperate tabs?

 

[Shane Devenshire]

Hi,

Although you can track changes in a Shared workbook, I don't think much of
them, so the fact that you can't use them under sharepoint is no loss.

You could have a macro highlight the changes when they are made and another
one to remove the highligthing.

Here is some sample code:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range

'Set isect = Application.Intersect(Target, Range("A1")) you don't need
this line unless you want to limit the area that gets formatted, if so change
A1 to that range.

If Not isect Is Nothing Then
Target.Interior.ColorIndex = 42
End If
End Sub

Not all changes will trigger this macro.