Save Date

  • Thread starter Thread starter tomen24
  • Start date Start 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
 
Back
Top