Exit Macro Help (Macro nested vba)

So I have about 4 or 5 macros that I call with another Macro.

The very first Sub has a dialogue box asking for a file, if I click Cancel it will exit the sub but it continues on to the next sub in the list of course.

I need it to stop processing the original macro. Does that make sense?

Please Login or Register  to view this content.

So within the ImportSheet sub, if user clicks cancel it will exit that sub but it goes on to the next macro..which I need to prevent.

Thanks!

(I know that I can combine these all into one sub and then the problem would be solved but I have them separate for a reason)

Originally Posted by dflak

Make the file name a global variable and check for it in subsequent subroutines.

That is way over my head, however right after posting I realized I could simply check for a sheet created after the import and if not there exit the sub. It works

Please Login or Register  to view this content.