Exit a Macro if Canceled

[brentjohn]

Greetings,
Not sure as to why my previous thread did not post. I have several macros to either Save or Print (PDF) a worksheet. I would like to insert code to cancel/exit the macro if the user presses the "Cancel" button on the SaveAs or Print dialog box (the computer standard dialog box). Here is a sample code:

Please Login or Register  to view this content.

[Richard Buttrey]

No me neither. I've never seen that 'Printable' View on the forum before. I'll close your earlier thread.

I'd be inclined to put your macro in the Workbook BeforeSave event procedure. That has a built in Cancel perimeter you can use to capture the situation where someone cancels. Similarly in the BeforePrint procedure.

[Fluff13]

No me neither. I've never seen that 'Printable' View on the forum before.

It automatically happens if the thread title ends in print.
If you change the last word of the title, it should correct itself.

[Richard Buttrey]

Thanks Fluff. That's a new one for me in my 11 years here but useful to know for the future.

I'd already deleted the original so I'll leave it on this occasion.

[mikerickson]

Try

Please Login or Register  to view this content.

[brentjohn]

mike,
Works perfect!
Thank you much!