View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Can I pass network logon name to a cell in a spreadsheet?

Hi,

This UDF should do that. Alt +F11 to open VB editor. Right click 'This
workbook' and insert module and paste this in

Function user()
user = Environ("Username")
End Function

Call with

=user()

Mike

"Quality Plan" wrote:

I want to be able to use the user logon name to crete a filter only for that
user out of a large data set. Does Excell have a function which passes the
network login user name to a cell?