How do I change the name of the group called Custom Toolbars in the Add-In tab of the ribbon?

kmdharan
kmdharan used Ask the Experts™
on
When I load a custom command bar via VBA into the Add-in tab of the ribbon, the group name defaults to Custom Toolbars.  Is there a way to change that name, either via the VBA code for the custom command bar or via XML coding in CustomUI?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Joanne M. OrzechManager, Document Services Center
Top Expert 2004

Commented:
The Ribbon Customizer will do it - but I don't know exactly HOW they did it!
http://word.mvps.org/FAQS/Customization/CustomizeRibbon.htm


Author

Commented:
Thank you for your comment.  The CustomUI editior I found on this site also lets me customize the ribbon in XML:
http://www.xtremevbtalk.com/showthread.php?t=265636

But that is not adequate for me.  What I need is a way to change the group name in the Add-In tab before loading a Command bar from VBA for Excel.  I am adding a number of button using the Application.CommandBar.Add feature in VBA.  These buttons automatically go into the Add-in tab of the ribbon with a group name "Custom Toolbars".  While I figured out how to rename the tab name from Add-in to something else using XML code, I have not figured out how to change the group name from "Custom Toolbars" to something else.
Commented:
Never mind.  There is no way to rename the group within the Add-Ins tab when you load a Custom Menu via VBA.  The best solution for the problem is to not load a custom menu via VBA.  Instead create a Custom tab in XML, name it whatever you want and use getLabel, getVisible, and onAction call back procedures to label, show and run procedures from the custom tab buttons.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial