stop macro from running after starting

[BradCollins]

How do you stop a macro from running after requesting it to start ?

I have setup my own Office Ribbon with various commands, each of these commands runs a macro. When I select an option from the ribbon it opens another form and closes the form I am currently working on (this works)
On one particular form I have it pop up a verification message that asks for confirmation to accept any changes (this also works) if the user selects to accept them, then on the onclose event of that form there are some additional checks that verify that required information has been entered.
If any of the required information is missing it will produce a message informing the user of this (this works), what I need it to do now is to return to the form with the missing information and not continue with opening the new form as per the request of clicking on a ribbon button. (This is my problem)

Currently everything seems to work with the exception that once I select an option from the ribbon all my code on the form runs without a problem, but at the end the macro from the ribbon still runs and shuts the original form and opens the newly requested one, not allowing the user the opportunity to enter any of the missing information

I hope this is clear and you can help. Thanks

 

[PHV]

Play with VBA instead of macros.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BradCollins]

I usually do and all of the code involved is in VBA. I am only using the macros as callbacks from the Ribbon and even then they only do two functions
1. Close the current form
2. Open the new form

All other commands are run in VBA