Using macro for UserID reading in Excel ( need help )

Set myshell = CreateObject("WScript.Shell")
ItsMe = myshell.RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\WinLogon\DefaultUserName")
Set myshell = Nothing

This program doesn't run. ( it's for reading User ID )
correct me if i am wrong , pls :)

This program doesn't run.
Could you try to be a little more descriptive please? :rolleyes:

I got that problem.
Can anybody show me . how to track UserID using excel macro when the user is viewing on that excel file...
:)

I'm not sure I know what you mean by "User ID"... there are quite a few names associated with an opened Excel document: There's the "Author" field in document properties, the user name you can set in the Options dialog, the name under which Office is registered, the current windows username, etc.

Is
msgbox environ("username")
any use?