NT Username

[ceemo]

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?

 

[Bob Phillips]

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]

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

 

[Dave Peterson]

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]

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