Automatically Add Header Footer to Excel Documents using VBA

How to automatically add a header or a footer and many other built-in document properties to an Excel worksheet using VBA.
Complete VBA code and sample file available here:

[chanchalagarwal]

Amazing Tip! If you could throw some light on how we can add some formatting (like bold and give different color) in the same VBA code, it will be pretty much helpful.

[nandkishore]

Thanks sir, Really it was chalange for me, i have done, with help of your vedeo, now i am super on my office.

[atifhussain]

Thanks Dinesh for your videos, I was wondering if instead of adding built-in properties, I can add for example a company logo on the top of my report. what would I need to do? Regards

[indianmonster]

I was trying some time Print automatically set company header-footers set…… using vba with 4 side perfect margins.
Header footer image based……
Please share help how to working with perfect margin

[shashikalagangappa]

great sir it is fantastic vba coding
its very useful

[vikrantrai]

Hello Dinesh Sir,

I am one of your biggest fan and your excel videos helped me a lot in my day to day work.

Sir, if you are providing classes in Delhi, I would like to learn VBA from you. if not then please recommend any Delhi (NCR) VBA institute from where I can learn the and implement it.

Would like to hear from you.

Regards,
Vikrant Rai
 

[ritajot]

thank you for your helpful videos. So, if I have filtered data in my (very big) sheet and I need print it, but header must be maked from one cell of this filtered data (sorry for my english)

[deepakkumar-llzs]

Dear Sir,
We can add User Name and computer name in header or footer if yes please Guide us.

[mohammadahmed]

Sir how we add header and footer in multiple files to gather .thanks

[TimBerlinXXX]

And how to format the document properties or add more text? :)

[nandkishore]

Sir how can i change it's font size