I have end users who create contracts in excel. The very last step for them
is to "Finalize" the contract. The part I would like to program would be the
printing portion. I need the macro to print 3 seperate tabs with a specific
amount of copies for each to the color printer. For example

Tab 1 would print 3 copies
Tab 2 would print 2 copies
Tab 3 would print 1 copy.

Is there anyway to do this with a macro? Thanks.