Updated times stamp of last change
 

I have a shared excel file. How do I display a time stamp of what time the
latest change was made?

Updated times stamp of last change
 

Several ways to do this.

Event code can be tailored to suit your needs.

Where would you like to see the timestamp?

On one sheet or on all sheets?

This sheet event code would give you a timestamp in B1 whenever A1 was changed.

I'm sure you have something more complex in mind, but example only..

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Target.Offset(0, 1).Value = Now()
End If
End Sub


Gord Dibben MS Excel MVP

On Fri, 30 May 2008 12:15:01 -0700, rciolkosz
wrote:

I have a shared excel file. How do I display a time stamp of what time the
latest change was made?