Cancel=True Not Working As Expected

[MikeDBMan]

I do a lot of coding for the event right-click. I end my additional steps with Cancel=True which used to always avoid popping up the incell menu. Now, for the past many months, the cancel=true seems to no longer work and I get an annoying right-click menu that pops up after my code executed. Suggestions?

 

[Fluff]

Do you have the Cancel=True in the right place?

 

[MikeDBMan]

I have cancel=true right before exit sub and yet the right-click menu then immediately pops up. I do call other subroutines before coming back to my BeforeRightClick sub.

 

[Rick Rothstein]

I have cancel=true right before exit sub and yet the right-click menu then immediately pops up. I do call other subroutines before coming back to my BeforeRightClick sub.

It might help for you to post your code for us to look at.

 

[MikeDBMan]

I do have some custom menu options on that right-click menu. Could that be the problem?

 

[Fluff]

If you step through the code with F8, does it ever get to the Cancel line?

 

[Rick Rothstein]

If you step through the code with F8, does it ever get to the Cancel line?

Or put a breakpoint on the Cancel line and let the code run normally to see if it ever stops on that line or not.

 

[MikeDBMan]

Yes it does.

 

[Fluff]

In that case if the next line is either Exit Sub, or End Sub, I can see no reason why you would still get the menu.

 

[Rick Rothstein]

Yes it does.

Hmm! Do you by any chance have Application.EnableEvents=False executing in your code sometime before the Cancel=True statement without having turned it off beforehand?