Last Updated Excel File

[meyerryang]

I know that if you look at the properties you can determine when a
spreadsheet was created it and who created it (username account). Can you
determine the last user who updated it?

 

[Jacob Skaria]

Use the below UDF.If you are new to VBA 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. Save. Get back to
Workbook.

Function GetDocProperty(strKey)
Application.Volatile
GetDocProperty = CStr(ActiveWorkbook.BuiltinDocumentProperties _
(strKey))
End Function

In any cell use the below formula
=GetDocProperty("last author")

If this post helps click Yes

 

[Jacob Skaria]

Use the below UDF.If you are new to VBA 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. Save. Get back to
Workbook.

Function GetDocProperty(strKey)
Application.Volatile
GetDocProperty = CStr(ActiveWorkbook.BuiltinDocumentProperties _
(strKey))
End Function

In any cell use the below formula
=GetDocProperty("last author")

If this post helps click Yes