I would like to have a cell display the last date a workbook was modified.
What would the code for that be?
Thanks in advance for any help.
I would like to have a cell display the last date a workbook was modified.
What would the code for that be?
Thanks in advance for any help.
You could use a Worksheet_change or Workbook_beforesave macro to populate a cell with the current date/time.
e.g.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets(1).Cells(1, 1) = Date
End Sub
pasted into the thiswokbook tab in the VBA editor (Shift F11)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks