Canceling a print job
 

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

Canceling a print job
 

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

--
Regards,
Tom Ogilvy


"Dan Scholler" wrote in message
...
What is the correct syntax in VBA to cancel a print job?

Canceling a print job
 

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.


On Sun, 8 Aug 2004 18:20:26 -0700, "Dan Scholler"
wrote:

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