Function LastAuthor()
LastAuthor = Activeworkbook.BuiltinDocumentProperties("Last Author")
End Function

This would be the name when installed, and you can change in
ToolsOptionsGeneral User Name.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Serum " wrote in message
...
Hey everyone. I was wondering how I could throw in some VB for a cell
that is like the last date modified codes, except that I want Excel to
input the user name of the person who made the last change into a
specific cell. If it's possible, how would I go about doing it?

Also, if this is possible and I throw the code in, where does Excel get
this username information from? Does it grab the name that was entered
when Excel was first installed? Is there a way to modify these things?
Without uninstalling/reinstalling?

Any help would be appreciated. Thanks.


---
Message posted from http://www.ExcelForum.com/