I have a workbook with multiple tabs. What I am trying to do is set it so that when you print the entire book it the pages of the first sheet will be 1 of 5 and then the second sheet will be 1 of 7.... I have it working as long as I select each tab individually... but if I print the whole book of 30 tabs it will do a 1 of 875 the second tab will then start the pages over to 1 of 875 and so on... I have the pages reseting but the stupid &[pages] is giving the total number of pages in the book and I just want the total number in the sheet.... has anyone found a solution for this?