| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically insert user name into Excel | Excel Discussion (Misc queries) | |||
| can i email an excel spreadsheet from office 2003 to a mac user | New Users to Excel | |||
| How do I automatically insert the user (login name) in Excel? | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I set up an excel spreadsheet to update every time a user . | New Users to Excel | |||
Linear Mode
