Display last time modified.

  • Thread starter Thread starter jboi
  • Start date Start date
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()
 
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.
 
Back
Top