Excel and VBA Menus and Command Bars

Floating Command Bar (zipped Excel file)
Floating Command Bar (text file)

This simple workbook contains the code to build a floating command bar when the file is opened, and delete it when it is closed. The command bar has two popup menus, each of which have two command buttons. No documentation supplied, just the file. Download either the complete Excel file, or the text file that contains just the VBA code you need.

Custom Drawing Command Bar.

Here is some code that generates a custom drawing command bar with my favorite built-in buttons. I originally wrote it for PowerPoint, but being part of the Office object model, it translated to Excel with only very minor adjustments. Both versions are shown.

Top of Page

Display FaceIDs

Display all 3000+ of Microsoft Office's built in button faces (screen by screen), so you can choose the right one for your special menu. Mouse over a button, and the ToolTip shows you its ID number. Click on one, and its image and number are stored in a worksheet for future reference.