Username question

[Dave]

Hiya

Does anyone know a formula or macro to show the username in a cell.

By username I mean either the name under Tools>Options>General or a
network logon name.

Best of all would be if the username could be part of the Header.

Any help will be much appreciated.

--
TIA
Da\/e
Please reply to group

Change to Firefox - rediscover the Web
http://www.mozilla.org/products/firefox
http://www.spreadfirefox.com

Reclaim Your Inbox!
http://www.mozilla.org/products/thunderbird/

 

[Chip Pearson]

Dave,

To get the user name displayed in the Options dialog, use
Application.UserName. To get the network user name, use
Environ("UserName")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dnereb]

to get a usersname you could use a little vba function:


Code
-------------------
Public Function UsName() As String

UsName = Environ("UserName")

End Functio