What is the correct syntax in VBA to cancel 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?

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?