Printing Odd/Even Pages in every worksheet

I am using this macro to print all of the odd or even pages in the active worksheet:

Please Login or Register  to view this content.

I am trying to edit the macro code to print all of the odd or even pages in every worksheet in the active workbook without any success.

I tried changing the

Please Login or Register  to view this content.

and it still only prints the odd or even pages active worksheet.

What changes do I need to make to print every worksheet in the active workbook?

Thanks,
Jason

Robert,
That code is a start but it does not fully help me.

I now know how to print the odd/even pages in the selected worksheet and how to print every worksheet in the workbook.

How do I print just the odd (or even) pages in every worksheet in the workbook?

Hi NCJason,

Maybe?

1.) On the Tools menu, point to Macro, and then click Visual Basic Editor.
2.) On the Insert menu, click Module.

Excel inserts a module called Module1 into your project.
3.) In the Module window, type the following code:

Please Login or Register  to view this content.

4.) Quit the Visual Basic Editor.
5.) On the Tools menu, point to Macro, and then click Macros.
6.) In the Macro Name list, click PrintOddEven.
7.) Click Run.

Hope it helps, Mike

Mike,
That code is very close to what I need, but it does not quite work correctly. My workbook has three worksheets in it and each worksheet has two pages.

When I run the macro it prints sheet one page one and sheet two page one but does not print sheet three page one. I am prompted to print the even pages and if I select yes it only prints sheet one page two.

Jason