Hello,

Connundrum.... I want to have a place on my excel worksheet that will display the last date it was saved, not opened, but saved. I went to the forums and found a bit of visual basic, but it doesn't seem to work. Here it is:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Stats").Range("P1").Value = Format(Date, "mmm dd yyyy")
End Sub

I am runing Excel 2000 and don't have a clue on how to get this to work. Any and all help appreciated.

-Robert-