Excel Question - Display User name

House · 7 Aug 2008 at 16:09

Ok how can I display the Users name in a cell in Excel.
Im talking about the one thats under the Options not a domain account name.
I know I've seen it done before but I cant for the life of me remeber how.

Any Ideas?

lolism · 7 Aug 2008 at 17:36

like this?

http://msdn.microsoft.com/en-us/library/kz965akc(VS.80).aspx

Cobertizo · 7 Aug 2008 at 19:22

The simple code in this link works well to give you the user's details from the Tools->Options settings:
http://www.mrexcel.com/forum/showthread.php?t=9442

I think the answer in the post above will give you the operating system / network ID.

House · 8 Aug 2008 at 09:24

Thanks for that, Thats excatly what i wanted (the second one), Only problem is while it works perfectly by default security settings on PCs here block all code and I've been told im not to instruct users to turn down there security settings.

Back to the drawing board I guess.