Last Modified across whole workbook

[Detectiveclem]

Hi can anyone help. I am trying to show on Sheet 1 the date & time when ANY of my work sheets have been modified.

I am using this code:

Function LastModified() As Date

LastModified = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

End Function


And then using this formula;

=Lastmodified(A:MM).

It works perfectly well to show the date of the last modification on that particular Sheet but how do I get the formula to capture any modifications which have taken place on the other worksheets within my workbook?

Any help would be appreciated.

 

[ParamRay]

Hello, your function returns the last time the workbook was saved.