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" <ceemo.1t4kqu_1122966326.8642@excelforum-nospam.com> wrote in
message news:ceemo.1t4kqu_1122966326.8642@excelforum-nospam.com...
>
> 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
>