Cool. Look forward to testing it out tomorrow.
Thanks much.


-----Original Message-----
Hi Crush

If you mean last saved date of the file??

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

Right click on the Excel icon next to File in the menubar
Choose view code
Paste this event there
Alt-q to go back to Excel

If you save the file the date will be placed in A1



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Crush" wrote in
message ...
Is there any way to have a field that will
automatically
display the date of the last update?

We have a calendar online that people are questioning
how
often it has been updating, so this would solve any
issues right from the start.

Thanks


.