Excel 2007 Custom Menu Buttons

**jo15765** · 03-13-2012, 10:03 AM

In Excel 2007 I have some VBA which creates custom menu buttons (it's in my personal vba workbook, set as a workbook open event) and then each of them have a macro assigned behind them. When the workbook opens these custom buttons are under the Add-ins tab, is there a way to set these to display under the "Home" Tab? I know I can use the UI Editor to modify the ribbon that way, but I was just trying to use my VBA coding to explicitly declare where to show the custom buttons.

**Andy Pope** · 03-13-2012, 11:59 AM

You have to modify the customUI xml if you want you buttons to be anywhere other than Add-in tab.

**jo15765** · 03-13-2012, 12:04 PM

That's what I thought. I was hoping I could just create a custom toolbar (like in 2000) and have that custom toolbar be the only toolbar that displays with all of my buttons. But I know the ribbon is a totally different world, and I will just have to get acclimated, and re-create my own custom "Ribbon"