Date Stamp

  • Thread starter Thread starter Maxwewll
  • Start date Start date
M

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
 
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.
 
Back
Top