How do I display the user details in a XLS sheet?

[Guest]

Is it possible to display the current user name within a cell of the workbook?

 

[Chip Pearson]

You can only do this with a VBA function.

Public Function UserName()
UserName = Environ("username")
End Function

For more info about getting document properties in Excel, see
www.cpearson.com/excel/docprop.htm


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

 

[Guest]

Where would you put this code - in the sheet, in a module or in the workbook?
I've tried pasting the code into various locations - I should be able to see
the name of the function when I got into the Paste Function dialog box, user
defined - right?