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

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

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

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



"CJ" wrote in message
...
Is it possible to display the current user name within a cell
of the workbook?

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

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?
--
maryj


"Chip Pearson" wrote:

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



"CJ" wrote in message
...
Is it possible to display the current user name within a cell
of the workbook?