Excel Custom Headers and Footer

[chandansify]

Due to a project requirement, I wanted to create custom headers and footers in Excel.

I know that I can add custom headers and footers manually using Page Setup but I want to do this using VBA.

Also, I have noticed that after adding a custom header and footer when I apply any other predefined header in my worksheet then my custom header does not appear again.

Can someone suggest how to retain the custom headers and footers in the drop down list?

Thanks in advance.

Regards,
Chandan Banga

[Bob Phillips]

Just do it in Excel with the macro recorder switched on, that will generate the necessary code.