I have a workbook with multiple worksheets; among those I have two worksheets, each of them has a different Header/Footer.
I named those HeaderFooterA and the other I have named HeaderFooterB.
When working on a certain Worksheet, say Sheet1, I would like to have a macro which would allow me to select the option for applying either HeaderFooterA or HeaderFooterB to Sheet1.
Could anybody help on this?
Thank you
Bookmarks