Home

Add author in footer

%3CLINGO-SUB%20id%3D%22lingo-sub-732883%22%20slang%3D%22en-US%22%3EAdd%20author%20in%20footer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732883%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EHow%20can%20I%20add%20in%20the%20footer%20of%20an%20excel%20file%20the%20name%20of%20the%20author%20who%20is%20modifying%20the%20file%3F%3C%2FP%3E%3CP%3EIs%20there%20any%20specific%20rule%20for%20this%3F%3C%2FP%3E%3CP%3Ethanks%20for%20the%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-732883%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732933%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20author%20in%20footer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369536%22%20target%3D%22_blank%22%3E%40annieb%3C%2FA%3E%26nbsp%3BYou%20can%20use%20the%20following%20code%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3ESub%20NameInFooter()%0A%20%20%20%20%0A%20%20%20%20ActiveSheet.PageSetup.CenterFooter%20%3D%20%22Elaborado%20por%3A%20%22%20%26amp%3B%20Environ(%22username%22)%0A%20%20%20%20%20%20%20%20%0AEnd%20Sub%3C%2FPRE%3E%0A%3CP%3EI%20would%20probably%20call%20it%20in%20the%20Before_Print%20event%2C%20but%20that's%20up%20to%20you.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHTH%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
annieb
Occasional Visitor

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

 

 

1 Reply

@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

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies