Jun 21, 2010
I am using Excel 2003 (under XP) to print to several printers, with several different kinds and sizes of stock. My workbooks consist of two sheets: "Data" and "Print." "Data" should never be printed. "Print" is laid out with the proper spacing for a particular stock, and should not be sent to the wrong printer.
View 1 Replies
I want to use a BeforePrint event to check that the active printer is correct and that "Print" is the active sheet. If either of these tests fail, I want to cancel the print event and replace it with a new one.
Here is the problem I am experiencing: Upon opening Excel, all printers function normally. The first time a BeforePrint event is cancelled, Excel gloms onto the active printer and subsequently tries to use its driver for all other printers. In the Print dialog, every printer selected will show the model of the cancelled printer next to "Type" and its location next to "Where," and the Properties button will bring up the preference menu for the cancelled printer. It is still possible to print to the other printers,
but the settings for the cancelled printer will be used, even if they are incompatible. This persists until Excel is closed and reopened.
BeforePrint events that do not cancel do not result in this problem. Events that do nothing BUT cancel, on the other hand, do.