Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing username
Hello,
I'd like to change the excel´s username (Tools/Options/Username) with the username of the windows (Documents Settings) just after opening the worksheet. Someone could help me with this vba code? Best regards Mauricio BR |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing username
If i understand you correctly, that you want to change the workbook username
to the name stored in the system for the current user, use this in the worksheet open event. Private Sub Workbook_Open() Application.UserName = Environ("UserName") End Sub -- -John Please rate when your question is answered to help us and others know what is helpful. "MauricioBR" wrote: Hello, I'd like to change the excel´s username (Tools/Options/Username) with the username of the windows (Documents Settings) just after opening the worksheet. Someone could help me with this vba code? Best regards Mauricio BR |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing username
That worked!
Thanks "John Bundy" escreveu: If i understand you correctly, that you want to change the workbook username to the name stored in the system for the current user, use this in the worksheet open event. Private Sub Workbook_Open() Application.UserName = Environ("UserName") End Sub -- -John Please rate when your question is answered to help us and others know what is helpful. "MauricioBR" wrote: Hello, I'd like to change the excel´s username (Tools/Options/Username) with the username of the windows (Documents Settings) just after opening the worksheet. Someone could help me with this vba code? Best regards Mauricio BR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.UserName Question | Excel Discussion (Misc queries) | |||
Show username in a cell | Excel Discussion (Misc queries) | |||
Show Username | Excel Discussion (Misc queries) | |||
Username Log | Excel Discussion (Misc queries) | |||
NT Username | Excel Discussion (Misc queries) |