Go back to before macro was run

[Wellworth]

I have used a "save as" macro that I found on this forum which I run as the first piece of code inside another macro. It works well but I find that if the user presses the cancel button at the "save as" screen the main macro keeps running. (of course it would). Any ideas how to exit the "save as" macro and the main macro to return to the point before the main macro was started.

Any help would be appreciated. The "save as" is below.

Please Login or Register  to view this content.

[mudraker]

Wellworth

Welcome to Exceltip forum

Please take a couple of minutes and read ALL theForum Rules

Your posting broke rule 3
I have fixed your posting for you

If you replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

The macro's will stop & not just exit back to the calling macro

[Wellworth]

Thank you Mudraker

As usual a very simple solution.

Have printed out and shall read all forum rules

Cheers

Wellworth