ExcelBanter - Last modified by

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Last modified by (https://www.excelbanter.com/excel-programming/419456-last-modified.html)

bugntl

Last modified by

Is it possible to find the last user who modified my file ?
Not with VB but with somekind of function ?

Gary''s Student

Last modified by

Without using VBA code, you could instruct openers to record their names in a
specific cell in a specific worksheet.

or

Right the file icon and select Properties Summary Advanced and read the
last modified field.
--
Gary''s Student - gsnu200811

"bugntl" wrote:

Is it possible to find the last user who modified my file ?
Not with VB but with somekind of function ?

dbKemp

Last modified by

On Nov 3, 10:37 am, bugntl wrote:
Is it possible to find the last user who modified my file ?
Not with VB but with somekind of function ?

This should do it from code:
ActiveWorkbook.BuiltinDocumentProperties("Last Author")

All times are GMT +1. The time now is 09:05 PM.