username

[robzrob]

Can i get workbook user name to appear in a cell?

 

[Gary''s Student]

Try this tiny UDF

Function uname()
uname = Application.UserName
End Function

 

[Gord Dibben]

You want UserName or Login Name?

See G'S's reply for Application Username.

For Login Name use this UDF

Function User()
Application.Volatile
User = Environ("UserName")
End Function


Gord Dibben MS Excel MVP