chandansify
03-31-2010, 03:52 AM
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
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