Can I automatically add user name to excel spreadsheet
 

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

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