"Date Last Saved" cell value

  • Thread starter Thread starter Dick Smith
  • Start date Start date
D

Dick Smith

I need a "Date Last Saved" cell in my Excel 2003 workbook, one that updates
when I save the file but doesn't update when I merely open it. I'm sure I
remember such a function in an earlier version, but can't find one in my
current version. Does it exist somewhere, or if not does anyone know a
workaround?

Thanks ==> Dick
 
Dick, here is one way, put in thisworkbook module

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)

'Now when you save the file the date will be put in sheet 1 cell A1

'change range as needed

Sheets("Sheet1").Range("A1").Value = Date
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Dick Smith said:
I need a "Date Last Saved" cell in my Excel 2003 workbook, one that updates
when I save the file but doesn't update when I merely open it. I'm sure I
remember such a function in an earlier version, but can't find one in my
current version. Does it exist somewhere, or if not does anyone know a
workaround?

Thanks ==> Dick
Click to expand...
 
Back
Top