CommandBar tools

 2006-05-11    Commandbars    3    165

This add-in lets you create a list of all available CommandBars in Excel, included a detailed list of all controls (menu items, buttons) on each CommandBar.
You can also view up to 10038 (depending on your Office version) available toolbar button symbols and their face id number that can be used on CommandBarButtons in Office97 or later. You can copy each symbol and use it any way you like.
This tool is useful for all that are creating their own custom CommandBars or customizes the built-in menus in any Office application.
After you open the tool you will find a new menu item EDC Tools in the Tools menu (in Excel 2003 or earlier), in Excel 2007 or later you will find the new menu item in the Add-Ins ribbon menu.
Click here to download this file.
Updated: 2006-05-11 Requires: XL97 File size: 66 kB

Leave a comment:

Your comment will only be published after it has been moderated and found spam free.
Your e-mail address will only be used to display your Gravatar.

malini kothari | 2018-09-29 09:09:05 (GMT)

Great code!

OPE | 2017-03-02 09:27:43 (GMT)

The CommandBars are unfortunately sort of obsolete after the Excel/Office 2007 version started to use the Ribbon menus.
Fortunately Ron de Bruin has written a lot about how you can customise the Ribbon menus.
Do a Google search for "Ron de Bruin Change the Ribbon in Excel" and you will find this information.

blb | 2017-03-02 08:39:47 (GMT)

hello there, i did successfully create menus, the problem is, if the users has not customized his ribbon to enable the "Add-Ins" menu from the ribbon, then, the added menus do not show up.

i can't find a way to include a line of vba code in my menu code so that the "Add-Ins" shows up on the ribbon.

kindly help, greatly appreciate.