Sharing Custom Menus

[jettrooper]

I am building a custom menu in VBA. This process pulls data from a SQL DB, which takes some time and a connection for each item in the menu. Now I need to have this same menu on each open Excel workbook so the user has access to it no matter which workbook they are on. The more workbooks that are open the more SQL calls and the longer the user has to wait for the menus to load.

Is there a way to simply copy a completed menu from one workbook to another?