Add a right click menu item to all workbooks

.
You can modify the BLANK EXCEL WORKBOOK TEMPLATE. This is the workbook that appears when you open Excel and click on New (to create a new workbook).
What you will be doing is creating a blank workbook with your right click menu added, then replacing the existing blank workbook template with yours.

This resource describes how to replace the existing blank workbook template in Excel :

https://www.extendoffice.com/documen...-template.html

I am pretty sure that events trigger only on the workbook the code is in, hence why it wont run when the personal workbook is hidden. A template may help if the code is placed within it but I doubt itd work retroactively. You could potentially consider writing it as an add-in, that might work though the code would have to be altered (likely alot). See info here as it looks like you can do it via ribbon as well, and the code is mostly without using events. May help you retool it for your needs. Its possible you may need to write your own class to do this.

In the attached workbook launched from xlstart is an addition to the cell menu to add a pre formatted date. All code is within and can be used in any workbook.