I test your Macro code and still find some problems. My main purpose is to show at the bottom of each page, the Left Footer shows like Page 1 of Sheet3, Sheet 3 is the third sheet of the workbook named Test.
The Right Footer shows like Page 10 of Test. Test is the workbook name. Page 10 is sequenced from the first page of Sheet1 to the first page of Sheet 3.
In your code processing result, the Left Footer is ok. But the Right Footer shows like the first Page 1 of Test, not the Page 10 of Test.
The problem is the page number count of LeftFooter is cumulative through the whole book, not from the first page to the last page of the current sheet.
Is it possible for you to fix it again?
Thank you very much.