I have a macro that send several sheets to be printed to the printer one at a time for formatting purposes. When someone else sends a job to the printer while the macro is running, sheets get mixed up.

Is there a way to "reserve" the printer until all the sheets have been sent by the macro to the printer so that they all come out on after the other.

Max

Maximus,

What obstacle do you face (from a formatting standpoint), of sending all of the sheets at once??

CarlR