Tracking changes in excel

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

Guest

I am trying to track changes that I am making to a workbook. This workbook
has 4 different worksheets. This workbook also has links in it so everytime
I go from one worksheet to the next it updates these links and then shows as
if I made changes to it when I didn't. When i go to tools and track changes
I've tried to choose the "where" but it only allows me to chose one worksheet
to select my criteria. When i try to put multiple sheets in the "where" it
says that my reference is invalid. Anyone have ideas?

Also, is there anyway to track changes like they track in microsoft word?
This would be even better and looks much nicer for what I am doing?
 
Try this exsample:
make a sheet e.g. Spy
put this code in all other sheets code-module

Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("Spy").Cells(Sheets("Spy").Cells(65500, 1).End(xlUp).Row + 1, 1) = Now
Sheets("Spy").Cells(Sheets("Spy").Cells(65500, 2).End(xlUp).Row + 1, 2) =
ActiveSheet.Name
Sheets("Spy").Cells(Sheets("Spy").Cells(65500, 3).End(xlUp).Row + 1, 3) =
Target.Address
Sheets("Spy").Cells(Sheets("Spy").Cells(65500, 4).End(xlUp).Row + 1, 4) =
Target.Value
End Sub


"mlayden" skrev:
 
Back
Top