Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last Updated Excel File
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last Updated Excel File
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 "meyerryang" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cells randomly don't get updated unless each cell is updated | Excel Discussion (Misc queries) | |||
Showing when a file was updated | Excel Discussion (Misc queries) | |||
Updated to Office 2007 - Saving Excel file error | Excel Discussion (Misc queries) | |||
How many copies of a file can be updated by the "File/Save" comma. | New Users to Excel | |||
How can I get notified whenever a certain excel file is updated (. | Excel Discussion (Misc queries) |