CODEWITHSUNDEEP
vbams-access-2010toolbaroffice-addins
AjStar08
AjStar08

Reputation: 25

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.

Upvotes: 0

Views: 881

Answers (2)

AjStar08
AjStar08

Reputation: 25

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.

Upvotes: 1

Sola Oshinowo
Sola Oshinowo

Reputation: 609

Check under access options, current database .............. It is likely it was created using macros, so you need to find the name of the macro, then edit the macro if need be.

i have attached two images.

  1. Shows the name of the macro under access options

  2. Shows the location of the macro under macro sections in navigation

Access options

Navigation Pane

Upvotes: 2

Related Questions