Forum Discussion

annieb's avatar
annieb
Copper Contributor
Jul 01, 2019

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

 

 

excel
Formulas and Functions
office 365

1 Reply

  • Smitty Smith's avatar
    Smitty Smith
    Former Employee
    Jul 01, 2019

    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

Resources