I am trying to write a macro that will print every sheet in the workbook, except for a short list (START, Main Data, Master Blank for ERC, P1 Figure 2-2, P2 Figure 2-2, P3 Figure 2-2, P4 Figure 2-2, P5 Figure 2-2, P6 Figure 2-2, P7 Figure 2-2, and P8 Figure 2-2). The remaining sheets are all formatted identically. Each is 2 pages, landscape, and same print area. The difficulty is that I need this to send to the printer as 1 job, because duplex printing and short-edge binding are options the user must select in the print preview window before actually clicking PRINT. It should not send as a different print job for each sheet. Thanks for the help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
