Adding icons to custom commandbar menus

[Justinlabenne]

Use the drawing toolbar to create the color squares you need and lace them on a worksheet. Give them decent names, then use the PasteFace method instead of FaceId

In your commandbar code:

Sheet1.Shapes("YourPictureName").Copy
MenuItem.PasteFace

See the attached gif.