Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Show last edited by
Is there a way to see who edited an excel file last? If you use windows explorer and look at the properties of an excel file you can see the last modified date you can also see who the original author is. I would like to see who made the last modifications.
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Show last edited by
'----------------------------------------------------------------- Function DocProps(prop As String) '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function and enter in a cell such as =DocProps ("last author") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dave H" wrote in message ... Is there a way to see who edited an excel file last? If you use windows explorer and look at the properties of an excel file you can see the last modified date you can also see who the original author is. I would like to see who made the last modifications. -- Dave H |
#3
|
|||
|
|||
This works great. Thanks
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show last number entered | Excel Discussion (Misc queries) | |||
Show data used and percent label | Charts and Charting in Excel | |||
leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
Show values from other sheet | Excel Worksheet Functions | |||
with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) |