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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies