Hi

I have an workbook that is used by many people and som of them hav
access to more functions.

Therefore I use Application.UserName to who is loged on.

If my real name is Carl Something I log on with abcaso but when I use
Application.UserName I get "Carl Something" but I want "abcaso"

Is it possible to get the name?

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***

Use

LoggedOnUser = Environ("Username")

--

HTH

Bob

"kalle" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
>
> Hi
>
> I have an workbook that is used by many people and som of them hav
> access to more functions.
>
> Therefore I use Application.UserName to who is loged on.
>
> If my real name is Carl Something I log on with abcaso but when I use
> Application.UserName I get "Carl Something" but I want "abcaso"
>
> Is it possible to get the name?
>
> Thanks in advance
>
> *** Sent via Developersdex http://www.developersdex.com ***

Hi,

Is this what your looking for

MsgBox Environ("UserName")


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"kalle" wrote:

>
>
> Hi
>
> I have an workbook that is used by many people and som of them hav
> access to more functions.
>
> Therefore I use Application.UserName to who is loged on.
>
> If my real name is Carl Something I log on with abcaso but when I use
> Application.UserName I get "Carl Something" but I want "abcaso"
>
> Is it possible to get the name?
>
> Thanks in advance
>
> *** Sent via Developersdex http://www.developersdex.com ***
> .
>