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
|