Total Number of Pages per Worksheet

[mcquilr]

Hi

I am trying to print an entire workbook to pdf at the same time. I have numberous worksheets in the workbook and each needs to be a seperate document which in the footer states page x of y.
I have managed to get all worksheets to print out starting at page 1 and running through my problem is the total number of sheets is coming out as the total number of pages per workbook instead of per worksheet. Can I use VBA code to get around this?

Thanks

 

[Andrew Poulsom]

Do you have Distiller? If so there is an example here:

http://www.exp-systems.com/forum_exp/forum_posts.asp?TID=39

Alternativeley you could try PDFCreator:

http://www.excelguru.ca/node/21