ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to Print Multiple Tabs with a Specific # of Copies (https://www.excelbanter.com/excel-programming/319458-macro-print-multiple-tabs-specific-copies.html)

Brad

Macro to Print Multiple Tabs with a Specific # of Copies
 
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.


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com