Display last time modified.

[jboi]

Is there a way to display in a worksheet the last time it
was modified or saved?

 

[Charles Maxson]

Put this in code:
________________________
Function LastSaved()
On Error GoTo FunctionErr

Application.Volatile
LastSaved = ActiveWorkbook.BuiltinDocumentProperties("Last Save
Time").Value
Exit Function

FunctionErr:
LastSaved = "File not saved"

End Function

________________________

and this in a cell:

=LastSaved()

 

[MOTS]

Hi Charles,
where should the code be entered?
Thnx.

-MOTS

 

[Charles Maxson]

In can be put in any VBA module...

FYI From Excel help....

On the Tools menu in Microsoft Excel, point to Macro, and then click Visual
Basic Editor.
1.. On the Insert menu, click Module.
2.. Type or copy your code into the code window of the module.
3.. If you want to run the macro from the module window, press F5.
4.. When you're finished writing your macro, click Close and Return to
Microsoft Excel on the File menu.