Solved: When Application.UserName is blank ...

[MWE]

I am helping a small company with a few office automation issues. When I have wanted to control who gets to do certain things in the past, I used Application.Username and compared it to a list of user name privledges. Unfortunately this company has decided that all applications will be loaded with no username (makes it easier to move systems around). So, that method is out.

How do I fetch the logon username?

Thanks

[Bob Phillips]

Use

[vba]
Environ("UserName")
[/vba]

it gets the logon name, they have to have one of those.

[MWE]

Use

[vba]
Environ("UserName")
[/vba]
it gets the logon name, they have to have one of those.

Thanks, that works well.