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

Try this tiny UDF

Function uname()
uname = Application.UserName
End Function

--
Gary''s Student - gsnu2007h


"robzrob" wrote:

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

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

On Sun, 4 May 2008 06:21:28 -0700 (PDT), robzrob wrote:

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