Retrieve User Name

[eBartlett]

I would like the user name to appear as a footnote in Excel. I have the syntax to access the network login id, but I want to capture the user's full name from Excel. Does anyone know how to do this?

 

[Chopsaki]

Application.Username?

 

[eBartlett]

It works! THANKS!

 

[eBartlett]

Same question, new twist. How do I get this information into the footer of all worksheets? The user may add worksheets and I want to make sure the username is captured on all of them? My macro appears below:


Private Sub Workbook_Open()
Worksheets("Event Wizard&quot.PageSetup.RightFooter = Application.UserName
End Sub

 

[Mossoft]

Put your code in the Workbook_NewSheet event

Private Sub Workbook_NewSheet(ByVal Sh As Object)

Sh.PageSetup.RightFooter = Application.username

End Sub