Print only certain worksheets?--Excel experts pls help

[cjones88]

I want to make a popup or some type of inquiry menu where it asks the user to specify which worksheets in the workbook to print. I have a data entry page, and four printable worksheets. Sometimes I only want to print two of the worksheets, but not the data page or the other two. Any way to do this besides printing the entire workbook or one worksheet at a time? It would be ideal if a popup menu came up with checkboxes for all of the available worksheets and the user could check off which ones to print.

 

[babact]

slightly different, and less complex

I have an issue that is less complex and I was wondering if there was any suggestions.

I have multiple worksheet objects that I have named. Currently my print macro looks like this

Inputs.PrintOut Copies:=1
Income.PrintOut Copies:=1

I have a central footer on each one of these pages that has the page number of pages (1 of 2, etc.). The issue is that the code I have written prints out each object individually and then moves on to the next one, so the footer of Inputs says 1 of 2, then the footer of Income says 1 of 2, etc. What I want to have happen is print them all at once, and have the footer say 1 of 4 on the 1st page of inputs, and 3 of 4 on the 1st page of Income.

Any thoughts?

Thanks.