vbaDeveloper icon indicating copy to clipboard operation
vbaDeveloper copied to clipboard

Menus aren't available

Open bweight opened this issue 9 years ago • 3 comments

I'm having trouble getting the menus to load. I've confirmed that the procedure is running, but the menus are not showing up in the Ribbon.

I've looked all over in the Ribbon customization settings and can't find them there to turn on.

I looked at the Application.CommandBars(1).Controls and I can see VbaDeveloper as one of the controls, but they are not visible.

Any help is appreciated.

bweight avatar Dec 02 '15 02:12 bweight

I have the same issue. No menus.

lysakowski avatar Apr 03 '16 07:04 lysakowski

The same problem.

temush avatar Apr 04 '16 22:04 temush

Just got this to work in Excel 2013. Here's what I did:

  1. Followed the instructions in Build.bas.
  2. Made sure to save my version of 'vbaDeveloper.xlam' after testImport() ran successfully. You'll know it works if in the VBA Project Explorer -> VbaDeveloper (vbaDeveloper.xlam) -> Modules folder you see more than just "Build" (ErrorHandling, Formatter, Menu et al.).
  3. Closed and relaunched Excel (in hindsight probably not necessary, but, this is what I did).
  4. From Excel (not the VBA editor) navigated to: File -> Options -> Add-Ins selected "Excel Add-ins" in the drop-down menu at the bottom of the panel labeled "Manage:" and clicked the "Go..." button.
  5. From the Add-Ins dialog (opened by the previous step), clicked the "Browse..." button and selected my "vbaDeveloper.xlam" file from step 1.
  6. At this point, "Vbadeveloper" was now showing in the "Add-Ins available:" list menu back on the Add-Ins dialog. I simply ensured that it was checked, then clicked the "OK" button.
  7. Once again closed and relaunched Excel. At this point I finally had a new "Menu Commands" group visible in the "ADD-INS" ribbon menu with a "VbaDeveloper" drop-down menu.

Good luck. :smile:

chrnola avatar May 05 '16 17:05 chrnola