Call Sub for sheet selection - continues onto next lines of code even if you cancel

**CC268** · 02-03-2017, 05:20 PM

I am hoping someone can help me here. I have the following code below I took from a fellow on MrExcel. I call this out to allow the user to select what sheet they would like to use the code on. However, I noticed if I press "Cancel" it continues to run the rest of the code that it is is called out in (highlighted in orange). Is there something I can do so that if "Cancel" is pressed it will actually exit the Sub and stop?

Select Sheet code:

Please Login or Register  to view this content.

Code that calls out the Select Sheet code:

Please Login or Register  to view this content.

**mikerickson** · 02-03-2017, 05:23 PM

Change the commented line to

Please Login or Register  to view this content.

**CC268** · 02-03-2017, 05:32 PM

Originally Posted by mikerickson

Change the commented line to

Please Login or Register  to view this content.

That didn't work - the thing is I don't think anything needs to be changed in the Sheet_Selector code at all. The problem is that the code continues to run AFTER "Call Sheet_Selector" even if you press the cancel button. The Sheet_Selector code may be exiting the Sub, but it is not existing the Sub that it is called out in...so it continues to run - you will see the enxt lines of code copy the sheet over into the workbook and begins to format it...I don't want it to do anything if the cancel button is pressed!

I guess what I am trying to say is that I think something needs to be palced in the second code after "Call Sheet_Selector" so that it ends the Sub IF the cancel button is pressed...but I have no idea how you would do this.

Call Sub for sheet selection - continues onto next lines of code even if you cancel

LinkBack

Thread Tools

Rate This Thread

Display

Call Sub for sheet selection - continues onto next lines of code even if you cancel

Re: Call Sub for sheet selection - continues onto next lines of code even if you cancel

Re: Call Sub for sheet selection - continues onto next lines of code even if you cancel

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Code works great...UNTIL i call it from another sheet- Why?

code not working If i call from a nother sheet?

VBA code continues to return to specific cell after data is entered

Excel Macro code to move data from one line on a sheet to multiple lines on another sheet

Calling the same userform, continues to run through after the "call"

Saving a sheet with code as a .prn, but the lines of code are too long?

Need to change row height of blank lines in selection, Sheet, or Document

Code causes Error 1004 then continues

Bookmarks

Bookmarks

Posting Permissions