Hi,

You could use the Before save workbook event

Alt+F11 to open VB editor. Double click 'This Workbook' and paste this in on
the right.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
lastrow = Sheets("Sheet3").Cells(Cells.Rows.Count, "A").End(xlUp).Row
Range("A" & lastrow + 1).Value = Now
End Sub

"Cando :o)" wrote:

Is there a way to time stamp when a change/revision has been made to an excel
worksheet? For example, I have a weekly input of data...I want to know what
day that input was made last...so that if someone turns in the worksheet and
a change was made on Tuesday (and it's Friday)...I'll know that anything
after Tuesday is not entered.
--
Thank you!