Get application user name or change it
Originally from https://www.vbausefulcodes.com/vbausefulcodes/87/change-user-name-with-vba
Sub SetAppUsername(NewUserName) ' Change User Name with VBA
' You can change the default username with vba.
' This is the default name that shows in "macro recorded by", new comments, "last saved by" etc...
' https://www.vbausefulcodes.com/vbausefulcodes/87/change-user-name-with-vba
Application.UserName = NewUserName ' "vbausefulcodes"
End sub
Function GetAppUserName()
GetAppUserName = Application.UserName
End Function
' You can change the default username with vba.
' This is the default name that shows in "macro recorded by", new comments, "last saved by" etc...
' https://www.vbausefulcodes.com/vbausefulcodes/87/change-user-name-with-vba
Application.UserName = NewUserName ' "vbausefulcodes"
End sub
Function GetAppUserName()
GetAppUserName = Application.UserName
End Function
None
or
NewUsername
or
NewUsername
Views 97
Downloads 44
CodeID
DB ID