Excel tracking changes

[Latha]

Hi,

I'm working on a spreadsheet which eventually will be used by my colleagues as a template to perform a series of calculations. I was wondering if there was any way of generating a permanent audit trail to track changes to the spreadsheet i.e. by who (perhaps linked to network logon),when and what was changed (old and new values)

Please help me

Regards,
Latha

 

[Latha]

Please revert soon

 

[Latha]

Hello all,

I have got the below VB code for accessing my objective as mentioned below.

But, Currently, the changes are presented in one cell (for example : "latha changed cell B2 from Audit to Audit trail") i need to separate this value so that coloum A shows User IDs (who made the change) column B shows text "Changed cell", Column C shows name of a Cell changed, and so on..

I tried "Text to column" option from DATA menu on the toolbar. this option doesnt give proper information when there is a new addition of information in the cell. for example ("Latha changed cell C2 from to New information").
but here i am adding a new information/value to a blank cell.

Plz guide me the way to segregate the value.

VB : -
Dim PreviousValue
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value <> PreviousValue Then
Sheets("log").Cells(65000, 1).End(xlUp).Offset(1, 0).Value = _
Application.UserName & " changed cell " & Target.Address _
& " from " & PreviousValue & " to " & Target.Value
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
PreviousValue = Target.Value
End Sub