You can use this to set your update date.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("B9").Value = Date
End Sub

You can use this to show the last time the file was opened, but you will
need to be sure to save the data. Most likely your Last Opened and Last
Updated dates will be the same, unless you want a time stamp. Do you want a
time stamp?

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A2").Value = "Last Opended - " & Date
End Sub

Hope this helps! If so, let me know, click "YES" below.
--
Cheers,
Ryan


"outrigger" wrote:

Using 2003. I have a work sheet, at the bottom I have "Updated" and in the
next cell I simply put in =Now(). This brings up the date and time each time
I open. Now what I want to do is see when I last opened and updated. How
can I do this