Search code examples
vbams-access-2010toolbaroffice-addins

Where is the "Add-Ins" custom menu stored in an office VBA application?


I am working on a legacy MS Access 2010 database project, and I cannot find where I can review and edit the custom "Add-Ins" toolbar. This is the custom toolbar:

Add-Ins tool bar

This project was previously migrated from a version prior to the ribbon world, hence I am not able to find any table or xml file with the custom toolbar menu. I can only show and hide the Add-Ins toolbar here:

Options

I found here that the custom toolbar is contained in some CommandBar object, but I still cannot find where it is defined and how to modify the toolbar and the actions on button clicks.

Thank you.


Solution

  • I finally found a function inside a module which is creating the menus. It seems that in this case, the menus are manually created/updated running that function manually, so I had to go to view code (Alt+F11), place the cursor inside the function and hit F5 to execute.

    One sample of code how to create/edit custom menus with this technique can be found here, but in the new versions of office VBA can be done like this.