UnCall a sub routine

**shiftyspina** · 02-12-2015, 08:20 AM

Hi

I have a code

Please Login or Register  to view this content.

Which works fine, but I need it to stop when selection changes?

I have tried STOP, END, UNCALL, but cant get this to work? what is the code needed to stop FlashBack Sub?

Thanks

Dan

**mehmetcik** · 02-12-2015, 08:26 AM

Please post a copy of Flashback

**shiftyspina** · 02-12-2015, 09:06 AM

Please Login or Register  to view this content.

**mehmetcik** · 02-12-2015, 09:15 AM

Ok you are asking the user to select a cell to stop the macro.

So at the top of your module declare a public variable

Please Login or Register  to view this content.

Now you need to Set the Stop Flag

so right click on the sheet name at the bottom of excel and select view code

paste this code there.

Please Login or Register  to view this content.

Now modify your code .

Please Login or Register  to view this content.

**shiftyspina** · 02-12-2015, 10:12 AM

That is spot on thank you very much

**shiftyspina** · 02-12-2015, 10:25 AM

is there a way to only run this code if it is called from say worksheet1, rather than when I open worksheet2 which is where the flashback occurs?

I have hyperlinks which link to cells I want to flash, but if go into this worksheet then it still runs, I would ideally like to remove that

**mehmetcik** · 02-12-2015, 01:27 PM

The selection change macro is sheet specific

so put it in the sheet where you want it to act.

UnCall a sub routine

LinkBack

Thread Tools

Rate This Thread

Display

UnCall a sub routine

Re: UnCall a sub routine

Re: UnCall a sub routine

Re: UnCall a sub routine

Re: UnCall a sub routine

Re: UnCall a sub routine

Re: UnCall a sub routine

Thread Information

Users Browsing this Thread

Similar Threads

Pass a variable from one sub-routine to another sub-routine

Sub Routine Name

Why won't this routine run?

This routine just keeps on going! Why?

[SOLVED] VBA routine (101)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions