Forum Discussion
Excel 365 - Header, Footer, and Print area
I have an Excel workbook with 20 tabs. Each tab has a different header except the date after the description of the particular sheet. I need every sheet to have a footer with a page number starti...
Thank you, but that did not work.
In what way did it fail?
- There is only one page per each tab (20 tabs) The code you gave me is not keeping the Print area that I had set up for each tab. Since it now has a different print area per tab, it is causing each tab to have multiple sheets and creating a number for those sheets.
Plus it removed my customized header on all the sheets. I have a different header on every tab, and only the date needs changing every month.Make sure that you haven't selected multiple sheets when you run the macro.
I have tested the macro; it does not change the page headers of the individual sheets, nor the print area.
It only sets the page number in the page footer.