Create a UDF in a standard Code Module

Function ThisUser()
ThisUser = Environ("UserName")
End Function

and then use like =ThisUser()

Tested on XP with XL97, not NT, but I would hope it works the same.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ceemo" wrote in
message ...

Hi, im not sure if this is possible but i thought i'd ask.

FYI - Excel'97


I use at work excel on nt where everyone has to log in using there NT
profile. Is there anyway to incorrporate there username into my
spreadsheets. We are able to do this with access im not sure how and i
thought it may be possible on excel. It would be a great benefit to
myself where we have spreadsheets that get updated by many people this
would log there details?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=392062