Excel Books

Books that I own and use while developing in Excel

Here are a few tricks I use for making menus and command bars for my Excel projects.


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.


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.