CommandBar Examples

CommandBar FaceIDs
This workbook contains more than 10000 built-in CommandBar-icons and their corresponding faceid-value available in Excel 2000 or later.
This tool is useful for developers that make custom CommandBars or menus in the Office applications.
Click here to download this example.
Updated: 2007-04-17 Requires: XL97 File size: 641 kB

CommandBar Tools
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.
Click here to download this example.
Updated: 2006-05-11 Requires: XL97 File size: 66 kB

Custom popup menu example
This workbook contains an example on how you can create a custom shortcut menu that is activated by a right-click in a worksheet or a UserForm.
Click here to download this example.
Updated:2002-07-19 Requires: XL97 File size: 18 kB

Workbook CommandBar
This example workbook shows how you can create a CommandBar every time a workbook is opened.
The CommandBar will only be visible when the workbook is active.
Click here to download this example.
Updated: 2002-04-02 Requires: XL97 File size: 17 kB

CommandBars with custom icons
Create your own commandbars with custom button icons.
You can also use pictures from external files as your button image.
Also demonstrates how you can determine which commandbar button that started a macro.
Click here to download this example.
Updated: 2001-02-26 Requires: XL97 File size: 36 kB

Create your own custom menu
This workbook shows how you can create your own custom menu. The example code shows how to create a menu with submenus. The submenus themselves can also have submenus. The example code also shows how to enable or disable menu items and how to add icons to the menu items.
Recommended: the CommandBar Tools available for download in this page.
Click here to download this example.
Updated: 2000-11-06 Requires: XL97 File size: 12 kB

Custom workbook menu
This workbook contains an example on how you can create a custom commandbar menu.
The custom menu is only visible when the workbook is active.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 15 kB

Another menu and submenu example
This workbook contains code that show how you can create a new menu with submenus, add a submenu to an existing menu, and add a submenu to an existing submenu. Together with the other menu example on this page, you ought to have a complete collection of the different possibilities with menus in Excel 97 or later.
Recommended: the CommandBar Tools, available for download in this page.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 17 kB

Create custom tooltips
Edit tooltips on any toolbar, designed for XL5/95, but will also do the job in XL97.
Click here to download this example.
Updated: 2000-08-08 Requires: XL5 File size: 7 kB Protected project

Attach a CommandBar to a workbook
This workbook shows how to attach a CommandBar to a workbook.
The CommandBar can be visible only when the workbook it's attached to is active.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 9 kB

Document last updated 2007-04-17 22:53:56 Printerfriendly version

User comments:

Ajit Passi from NJ, USA wrote (2005-07-09 06:52:25 CET):

Excellent Examples
Menus & Commandbars Examples are simplified beautifully. Perfect for personal as well as business needs. THANK YOU.

Ole P. from Norway wrote (2004-12-10 20:26:56 CET):

Re: How to attach submenus to pick up list items in excel
The built-in drop-down functionality in Excel doesn't support this.
You might be able to use a custom shortcut menu instead.
See the "Custom popup menu example" above.

Naveen from Chicago, US wrote (2004-12-10 19:48:22 CET):

How to attach submenus to pick up list items in excel
Hi, the information on this page is great, but what I am looking for is the following. I know how to create a pick up list and attach it to cells in Excel. However, I want to attach a subpickuplist to items on the pick up list. If you can help me with that, please email to navsinghal@hotmail.com Thanks.