Excel Tracking Changes

I

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?
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top