NT Username
 

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

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

Hi, firstly thanks for your help. What does UDF stand for?


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

User Defined Function.

It's like a function that's built into excel =sum(), but it's written by a user
(you or Bob!).

ceemo wrote:

Hi, firstly thanks for your help. What does UDF stand for?

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

--

Dave Peterson

well thanks for you help got it working just fine. Didnt realise at
first that it had to be placed in a module outside of a macro. thanks
again!


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