Save Date
 

Any way the spreadsheet can display the last save date time of the spreadsheet?

Save Date
 

Set the Security level to low/medium in (Tools|Macro|Security). From workbook
launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the
below function.Get back to workbook..

Function DocProperty(strQ As String)
Application.Volatile
DocProperty = ActiveWorkbook.BuiltinDocumentÂ*Properties (strQ)
End Function

For a already saved workbook enter the formula in any cell..
=DocProperty("last save time")

If this post helps click Yes
---------------
Jacob Skaria


"tomen24" wrote:

Any way the spreadsheet can display the last save date time of the spreadsheet?