|
Subject:
|
user name in the code
|
|
Posted By:
|
uhd42
|
Post Date:
|
5/16/2006 3:13:05 AM
|
hello,
In vba excel.
is there any way that i could use the author name of the worksheet or the user name that login the computer (much better),in the vba code and put it in a cell i want.
thanks
|
|
Reply By:
|
vemaju
|
Reply Date:
|
5/16/2006 3:22:34 AM
|
Hi,
Sub InsertUserName()
'*** User name
Range("A1") = Environ("Username")
'*** Author name
Range("A2") = Application.UserName
End Sub
-vemaju
|
|
