T Tom Ogilvy Aug 9, 2004 #2 There is no VBA syntax for this that I am aware of. You would probably have to use the Window's api.
M Myrna Larson Aug 9, 2004 #3 If you mean the print job has already started, there's no way in VBA to abort it. OTOH, if you mean the user tries to print and you want to prevent that, you can do that with an event macro. In the ThisWorkbook module, select the Workbook_BeforePrint sub. That sub has a Cancel argument. If your code sets it to True, printing is cancelled.
If you mean the print job has already started, there's no way in VBA to abort it. OTOH, if you mean the user tries to print and you want to prevent that, you can do that with an event macro. In the ThisWorkbook module, select the Workbook_BeforePrint sub. That sub has a Cancel argument. If your code sets it to True, printing is cancelled.
