Code to end a main sub before end sub point

[heliskier89]

I’m using this code to run consecutive programs, which works really well, apart from one little glitch.

Please Login or Register  to view this content.

The problem is that during the Sendmail sub if I select No on the vb, the program continues onto the next sub which unfortunately clears the data I have input to cells on the worksheet (as it should do).

I therefore need a piece of code which will end the main sub at this point, if No is selected, without running the saveaspdfwithdate2 coding.
Here is the coding for Sendmail

Please Login or Register  to view this content.

[mudraker]

Use End instead of Exit Sub

I would also change the structure of the If statement as you have yes/no option

Please Login or Register  to view this content.

[mudraker]

On 2nd thought I would replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[heliskier89]

Works great. Thanks alot mudraker.