I have searched the forum several way to resolve my issue and the only
solutions were as follows:


Formula:
--------------------

Public Function UserName()
UserName = Environ("username")
'UserName = Computer("UserName")
End Function
MsgBox Environ(”username”)

Option Explicit
Function NetworkUserName() As String
Dim response
NetworkUserName = Environ("Username")
End Function

--------------------


Problem is that I get a #REF! and #NAME! instead of the user names
I am using Excel 2000 (I can not upgrade, Government PC) pus we need it
to support Excel 2000 - present versions.

thanks


--
swieduwi
------------------------------------------------------------------------
swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962
View this thread: http://www.excelforum.com/showthread...hreadid=507221