Come out of righct click menu VBA

Celticfc

Board Regular
Joined
Feb 28, 2016
Messages
153
I have a custom right click menu where I load up a Userform.

When I close the Userform (either terminate it or unloadit), the right click menu still appears.
I have tried to select/activate another cell when closingbut Rightclick option still remains.
It’s really buggin for the end user to see the right clickmenu when they’ve already clicked an option on it and completed the userform.
I even activated another worksheet but even there the rightclick menu was still on…
Resetting list range popup did not help either, it just wentback to standard right click menu but was still visible after I closed the Userform.
I simply need to physically click on a cell for the rightclick to disappear, not activate or select another cell….
Is there anything else that I can try?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
At the end of your right-click code put 'Cancel=True' - this will cancel the right-click menu and just leave the cell active.
 
Upvote 0

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top