Page number sheets when printing Entire Workbook

[rdance]

I am trying to find a way to print an "entire workbook", but have each of the sheets paged as a group separate from the rest. One workbook typically has up to 20 sheets, with each sheet up to roughly 8 pages. I need each sheet set to show page 1 of 8 or page 5 of 8, not page 22 of 53. Counting and typing in the total number of pages in each sheet's footer is too cumbersome. Also, printing each sheet individually has also been cumbersome when printing to PDF. Are there any other ways to have the "&[Pages]" function only reflect the number of pages within the sheet instead of in the entire workbook?

 

[PRIMA]

Hi Peter,

What if I want to show my name in the header or footer for each sheet every time I print. What will be the code?

Thanks in advance.

Regards.

 

[Peter_SSs]

What if I want to show my name in the header or footer for each sheet every time I print. What will be the code?

Why do you need code? Couldn't you just manually put your name in the header of each sheet?

 

[PRIMA]

Hi Peter,

Thanks a lot for the reply.. The code was already given to me by Mr. VoG, Thank you so much for your time.

Regards.

 

[ttobgye]

Hi Peter,
Thanks. It worked. You are great! Only thing that I had to do extra was selecting all sheets first and then only pasting the code in 'View Code'.

REgards,
Tashi

 

[Peter_SSs]

Only thing that I had to do extra was selecting all sheets first and then only pasting the code in 'View Code'.

Could you please explain that in more detail?

 

[ttobgye]

If you refer my last second post (posted on 15th Fenruary), after the 4th step I have right clicked on one of the tab of a sheet and clicked on "select all sheets"......then continue with rest of the steps.

Hope that is clear.

 

[Ceciles]

I am experiencing two issues:
first, the workbook won't print in one go. After a few pages, it prints a page that says

error:invalidfond
OFFENDING COMMAND:xshow
STACK:
[43,34,37... ETC]

Print the whole workbook in pdf and print from there to quickly resolve this.

Second problem is, like the above poster, that i wish each every page of a worksheet to be numbered 1 of x in the header, but I wish to keep x of 114 in the footer (where 114 is the entire workbook number of pages). Is there anyway to do this?

Thank you!

 

[KEEEROW]

I am unable to get this working on excel 2010. Is there anything different that I have to do for excel 2010 from 2007?

 

[Peter_SSs]

I am unable to get this working on excel 2010. Is there anything different that I have to do for excel 2010 from 2007?

Welcome to the MrExcel board!

There have been a number of slightly different requirements posted during this thread so it isn't clear which one you are talking about. Please spell out accurately what you have and what you are trying to achieve.

 

[KEEEROW]

I am quite literally trying to do the exact same thing as ttobgye. I have gone through his same steps and even went through his fixes and yours. I was just wondering if there is anything different I have to do since I am using excel 2010.