Right click Function on excel to launch multiple macros

[Ravisca2003]

Hello All,

Thanks once again for wonderful guidance I have been getting from this forum . Today I want to post a new query to seek your help again.

Scenario
I have three macros which are very generic in nature ( can be used in any excel workbook e.g. "Delete all sheets from the workbook except active sheet"

Requirement
1.I want this macro to be invoked when the user perform a right click , all three macros should be listed for him to select
2. I want to have this enabled in all workbooks a user opens


Where I am stuck

Using internet help available , I was able to add the required code in order to populate the right click options however it is only available in the workbook in which I saved it. I understand this is logical for excel hence I tried to add the code in Personal workbook but when did so, the code is not giving option of right click in any workbook at all.

Further , I was only able to add one Macro right click function however the requirement is to have these three macros and more in future.
One of the reference i used is
https://www.extendoffice.com/documen...lick-menu.html


Please guide.

[MarMo]

You might have a look at Ron De Bruin's page :

https://www.rondebruin.nl/win/s2/win014.htm

He has alternatieves for multiple menu's and submenu's