As you can see, I'm using the FaceId-property to control the appearance of the little icon that precedes the option.

For several of my menu-entries however, I'd like to use icons that do not exist in the FaceID-list. Using Excel's Toolbar-Customize menu, I can manually do an "edit button image".
I'm not sure if and how I can do this from VBA. As I'm building and rebuilding the menu's based on the user's actions, I'd require code that would allow me to update this. also, as the icons ("button images") will be created by me (they will be quite simple); how (and where) would I store these for re-use when I'm rebuilding my menus... (I doubt if VBA would allow me to re-design at runtime)

Re: Menu/Right Click Face (ExcelXP)

The only way I know to do this, is to place the icons you want to use in a sheet (could be hidden), then when you are creating the button, copy the the appropriate image to clipboard and then paste it. Here is an example code snippet:

Re: Menu/Right Click Face (ExcelXP)

Custom toolbars are stored in your personal .xlb file - for Excel 2002 on Windows XP, it is
Cocuments and Settings<username>Application DataMicrosoftExcelExcel10.xlb
But you can attach a custom toolbar to a workbook, so that it travels with it: select Tools | Customize..., and click Attach... in the Toolbars tab.

Re: Menu/Right Click Face (ExcelXP)

You can create button images in any graphics editor, such as Paint. It is a 16 by 16 pixel with 16 colors.

If you have created a button image in the built-in editor:
- Select Tools | Customize...
- Right-click the button.
- Select Copy Button Image from the popup menu.
- Close the Customize dialog.
- Select the cell in the workbook where you want the image.
- Edit | Paste or Ctrl+V.

Re: Menu/Right Click Face (ExcelXP)

Got that... for various reasons, I decided to go for this option (copy faces from a sheet onto the toolbar i.s.o. from a hidden bar). So I created icons, copied them off the toolbar and into a sheet. Gave them a name...