Environ$ does not return the Username

[Lexian]

Hi,

I have worksheet that everytime I save, it display on the specific Cell the username of the Last User who modified it.

I used this code:

Please Login or Register  to view this content.

It was working fine with my computer and on one of my co worker, but suddenly it doesnt work on my Boss PC.
it was working fine before, now it stopped displaying his name every time he save it.

May I know what cause this? and some advise on the solution.

Thanks in advanse

[Fluff13]

Do you get any error messages?
if not add a message box & see if that appears

Please Login or Register  to view this content.

[pjwhitfield]

Our corporate network seems to have different users with different setups for USERNAME (including some that are blank) there are other ways to get it.

Try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Lexian]

Thank you all,

I think the Application.UserName works.
I will check on my Boss PC shortly.

regards

[Fluff13]

FYI
Application.Username returns the user name for Excel, not your windows login name.
Therefore very easy for a user to change the name in xl to somebody else's name, by going to File > Options > general > Personalise your copy.

[Lexian]

Hi all,,
I checked my boss PC and its still not working..

[romperstomper]

Does it give an error or just not work? Has he restarted Excel?

[Lexian]

No error,
I tried to add a message box and it appears.

[romperstomper]

If you have access to his pc, open a command prompt (Windows key + r, then type cmd and press enter), type SET and press enter. Do you see Username listed with a value?