View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Can I automatically add user name to excel spreadsheet

hi
you could have a macro return the user name
Sub usename()
MsgBox Environ("UserName")
'or
'[A1]=environ("UserName")
End Sub

or you could create a functions to retrun the user name
Public Function UseName()
UseName = Environ("UserName")
End Function

then use the formula on the sheet.....
=UseName()

regards
FSt1

"LRL_in_KC" wrote:

We have a template to create a form that I would like to have the users name
added to so I can tell who created the form