I work for a Cable Company and i have a worksheet that gives me details of
subscriber #'s. Each tab is a city. For example tab 1 is called Edina, MO;
tab 2 is called Hannibal, MO, etc. Now each tab is roughly about 4 pages. Now
i have to print these out for certain co-workers but the catch is each
co-worker requires different details from my report.

Co-worker #1 needs all tabs with all 4 pages of details
Co-worker #2 needs all tabs but only requires 1 page
Co-worker #3 needs all tabs but only requires pages 3 and 4.

Is there anyway to set up a macros where if i press Cntrl + P a message
window box appears that gives me the option on who to print for? And if so
how do i do that and set up the print jobs. If needed i can email the report
to you guys to look at.

Thanks Greg

How about just recording 3 (or more) macros that print exactly what you want.

Then you can just run these macros when you need to print that portion.

I'd name the macros nicely, too:
GregsPrintReport
....

Gregory Sharofsky wrote:

I work for a Cable Company and i have a worksheet that gives me details of
subscriber #'s. Each tab is a city. For example tab 1 is called Edina, MO;
tab 2 is called Hannibal, MO, etc. Now each tab is roughly about 4 pages. Now
i have to print these out for certain co-workers but the catch is each
co-worker requires different details from my report.

Co-worker #1 needs all tabs with all 4 pages of details
Co-worker #2 needs all tabs but only requires 1 page
Co-worker #3 needs all tabs but only requires pages 3 and 4.

Is there anyway to set up a macros where if i press Cntrl + P a message
window box appears that gives me the option on who to print for? And if so
how do i do that and set up the print jobs. If needed i can email the report
to you guys to look at.

Thanks Greg

--

Dave Peterson