Time stamp revisions (not just when open/print file)

[Cando :o)]

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.

 

[Mike H]

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

 

[Shane Devenshire]

Hi,

If you want to keep track of revisions, you will need to either create a VBA
routine to do it (probably a lot of work) or turn on Shared Workbooks with
Track changes. The are a fair number of downsides to shared workbooks, but
take a look at the topic area in the help system and see if it meets your
needs.