Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Menus aren't available #16

Open
bweight opened this issue Dec 2, 2015 · 3 comments
Open

Menus aren't available #16

bweight opened this issue Dec 2, 2015 · 3 comments

Comments

@bweight
Copy link

bweight commented Dec 2, 2015

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
Copy link

I have the same issue. No menus.

@temush
Copy link

temush commented Apr 4, 2016

The same problem.

@chrnola
Copy link

chrnola commented May 5, 2016

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. 😄

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants