Forum Discussion
annieb
Jul 01, 2019Copper Contributor
Add author in footer
Hello, How can I add in the footer of an excel file the name of the author who is modifying the file? Is there any specific rule for this? thanks for the help
Smitty Smith
Jul 01, 2019Former Employee
annieb You can use the following code:
Sub NameInFooter()
ActiveSheet.PageSetup.CenterFooter = "Elaborado por: " & Environ("username")
End Sub
I would probably call it in the Before_Print event, but that's up to you.
HTH