ExcelBanter - username

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - username (https://www.excelbanter.com/excel-worksheet-functions/186121-username.html)

robzrob

username

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

Gary''s Student

username

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?

Gord Dibben

username

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?

All times are GMT +1. The time now is 06:11 AM.