Custom Menu - Macro Bank

[furbmikey]

I'm looking to create a custom menu, similar to the one I have attached, that pulls macros from a shared folder and updates for new additions to the folder. The attached example actually lists each macro in the code, however, I'd like to create something more dynamic that simply looks in a folder and updates the list.

Thanks in advance for any contributions to the thread.

[scottiex]

You can just create an auto_open macro to open a read only file every time your file opens (an add in or a hidden macro enabled excel file).
Then update the macros in that second file.
You code for the bar would be in that second file.