End All Macros - But Keep Userform Active

[FallingDown]

Hi all

I have following piece of code in a lengthy macto

Please Login or Register  to view this content.

This ends all macros, as intended. However. I would like to keep the userform open, as well as the data entered to remain the same.
Is there a way to end all macros, but keep the userform open and active?

Thanks
FD

[xlnitwit]

Hi,

Briefly, no. What macros do you actually need to stop? In general, using End on its own is bad practice.

[sintek]

Hi FallingDown

Surely Adding a message and EXIT SUB code prior to ending IF Function will suffice....
Edit...
Upload a sample of your workbook and I am sure that someone will come up with a solution...

[FallingDown]

Hi xlnitwit

Bascially the macro starts with the user entering details in a userform.
When he/she clicks "save" (command button) 4 subsequent macros run, each dependant on the previous, reading information generated from running the macro.
The macro is interfaced with other applications, thus requiring a password input, which is verified based on the other applications feedback. Initially I wanted the macro to end and have the user execute the command button again.

However, upon reading your post, I thought I should quit the second application (to ensure start-up is in the right position), and use a GoTo command, having the code reopen the app.

Thanks anyway

FD