View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default 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