search

hilkoc / vbaDeveloper

Tools for development and version control of vba code
MIT License
510 stars 138 forks source link

Menus aren't available #16

Open bweight opened 8 years ago

bweight commented 8 years ago

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.

lysakowski commented 8 years ago

I have the same issue. No menus.

temush commented 8 years ago

The same problem.

chrnola commented 8 years ago

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: