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?