Using Cancel with On Error GoTo

**brentjohn** · 09-02-2018, 11:47 AM

Greetings!
I am wanting to use "cancel" within my macro that contains an "On Error GoTo". I would like for Sheet 68 M28 to have a 1 if the PDF has been created. A 22 if the PDF was not created due to an existing PDF with same name opened. And a 33 due to cancelling the PDF. I am using the following code, but cannot seem to get the cancel part to work.

Please Login or Register  to view this content.

**Kaper** · 09-02-2018, 04:12 PM

This part:

Please Login or Register  to view this content.

is never executed.
It shall be located before "proper" part. So:

Please Login or Register  to view this content.

PS: note added swithing back on

Please Login or Register  to view this content.

on all exit routes

**brentjohn** · 09-03-2018, 08:04 AM

Kaper,
Thank you much!!! Works GREAT!!!

**Kaper** · 09-03-2018, 09:55 AM

Glad it worked, and thanks for marking thread SOLVED and for rep. point

Using Cancel with On Error GoTo

LinkBack

Thread Tools

Rate This Thread

Display

Using Cancel with On Error GoTo

Re: Using Cancel with On Error GoTo

Re: Using Cancel with On Error GoTo

Re: Using Cancel with On Error GoTo

Thread Information

Users Browsing this Thread

Similar Threads

Error message appears ("Run-time error '4198'...) when clicking Cancel in Save As window

[SOLVED] .Match with On Error: On Error Resume Next works. On Error GoTo only works once. Err.Clear

[SOLVED] Error Occurs while running to On Error Goto Line3

Run-time error '91' when 'On error goto' and cells.find

[SOLVED] On Error Goto (Global Error Handling)

[SOLVED] Error Handling - On Error GoTo doesn't trap error successfully

Use of ON ERROR GOTO 0

Bookmarks

Bookmarks

Posting Permissions