There are two names:
1. login name
2. user name specified in Tools Options General User name
here are two User Defined Functions:
Function officeUser() As String
officeUser = Application.UserName
End Function
Function LogOnName() As String
LogOnName = Environ("username")
End Function
UDFs are very easy to install and use:
1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window
If you save the workbook, the UDF will be saved with it.
To use the UDF from the normal Excel window, just enter it like a normal
Excel Function
To remove the UDF:
1. bring up the VBE window as above
2. clear the code out
3. close the VBE window
To learn more about UDFs, see:
http://www.cpearson.com/excel/Writin...ionsInVBA.aspx
--
Gary''s Student - gsnu200835
"Don" wrote:
Within Excel , can it tell you the name of the person who is accessing the
file =
1) The name they put in Excel or
2) System Login ID (from NT?)
thanks in advance