How can I display a user name is Excel?
 

Rather than having everyone enter their name in a spreadsheet before printing
their reports I was wondering if there is a function that would display the
user's user or display name in a cell.

Thanks,
Phil

How can I display a user name is Excel?
 

not sure what you want to do, but this line of code would enter the username
that was used to log in to windows into cell A1

range("A1").Value = environ("username")
if you need more info, post back.
--


Gary

"Phil_M" wrote in message
...
Rather than having everyone enter their name in a spreadsheet before
printing
their reports I was wondering if there is a function that would display
the
user's user or display name in a cell.

Thanks,
Phil