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?
|