Show Date File was saved

I

Imry

I need to show in Excel, inside a cell, the date the the
file was last saved.
Is this possible?
 
R

Ron de Bruin

Hi Imry

You can use this event in the Thisworkbook module

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)If you save the file the date will be placed in cell A1of Sheet1
Sheets("Sheet1").Range("a1").Value = Date
End Sub
 
R

Ron de Bruin

Oops

This is better

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
'If you save the file the date will be placed in cell A1of Sheet1
Sheets("Sheet1").Range("a1").Value = Date
End Sub
 
Top