vbaDeveloper
vbaDeveloper copied to clipboard
Menus aren't available
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.
I have the same issue. No menus.
The same problem.
Just got this to work in Excel 2013. Here's what I did:
- Followed the instructions in Build.bas.
- Made sure to save my version of 'vbaDeveloper.xlam' after
testImport()
ran successfully. You'll know it works if in theVBA Project Explorer -> VbaDeveloper (vbaDeveloper.xlam) -> Modules
folder you see more than just "Build" (ErrorHandling, Formatter, Menu et al.). - Closed and relaunched Excel (in hindsight probably not necessary, but, this is what I did).
- 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. - From the Add-Ins dialog (opened by the previous step), clicked the "Browse..." button and selected my "vbaDeveloper.xlam" file from step 1.
- 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.
- 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: