Printing Macro for Excel 2002 & 2003

Hi There,

I'm working on creating a workbook for excel 2002 & 2003 which has 5 separate worksheets. Each worksheet has 8 page breaks that I have set up, giving the user 8 pages to work with. My problem, however, is that they don't always need all 8 pages on all 5 worksheets. For example, on the first worksheet, you may need to print 5 pages, and on the other 4 worksheet you only need one or two. I need a macro that will allow me to not only select which worksheets that I want to print, but also select the specific pages within each worksheet I need printed. I found a VBA code online that lets me select the worksheets I need, but I don't know how to add in code to allow me to select pages from each worksheet. The code I found is as follows:

Please Login or Register  to view this content.

Any help on this would be great,

Thanks