Date Stamp

[Maxwewll]

Hello,

I have a worksheet that I have some people working on
(work in progress). I need the spreadsheet to date stamp
each time anyone goes in and alters the sheet. Basically
I want to say "Last update was: (Date Stamp)"

Please help

 

[Jim]

Have you looked at Tools>Sharing>Track Changes?

 

[Norman Harker]

Hi Maxwewll!

One way you might consider is to use a Workbook_BeforeSave event
handler:

Private Sub Workbook_BeforeSave(ByVal _
SaveAsUI As Boolean, Cancel As Boolean)
Sheets(1).Range("A1") = "Last saved " & Now
End Sub



This goes in the ThisWorkbook module.






--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.