Canceling a print job

[Dan Scholler]

What is the correct syntax in VBA to cancel a print job?

 

[Tom Ogilvy]

There is no VBA syntax for this that I am aware of. You would probably have
to use the Window's api.

 

[Myrna Larson]

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.