On Sun, 07 Sep 2008 06:51:46 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

You want Excel username or login username?

There is a difference.

Function User()
Application.Volatile
User = Application.UserName 'name in ToolsOptionsGeneral
End Function

Function login()
Application.Volatile
login = Environ("Username")
End Function


Gord Dibben MS Excel MVP



The 2nd one is the one for me sir. All I need now is to be able to
record/saxe the username of whoever opened/closed the sheet lasr.

Any hlep greatly appreciated

On Sun, 07 Sep 2008 08:55:30 +0100, wayne wrote:

Hi, is there a way that I can find who the active user(s) is/are? ie
Name or staff number etc

TIA
Wayne