In Your Customized Excel Toolbars, Debra Dalgleish asks what customizations we’ve made to our Excel toolbars. I have a large set of customizations which load and unload programmatically when my personal macro workbook loads. The Standard and Formatting toolbars stretch across the top of my screen, so I’ve undocked them and resized them to fit their controls on several rows for easier display. This gave me enough room to open my custom charting menu (but not my custom tools menu), so I’m sharing it as well.

Some of the buttons are built-in buttons that don’t normally appear on these toolbars, and a number of them are linked to VBA procedures. A few are even obsolete, like the Reformat Chart(s) control on the Jon’s Charts menu and on the Formatting toolbar. I haven’t updated the procedure that adds the buttons (a plumber’s sink always leaks, eh?), so some of the buttons are not transparent, and some of the paste buttons are always enabled, even with an empty clipboard. But it’s my interface, so I’m used to its idiosyncrasies. Several of the custom functions have been featured in my web site and blog.

Usually when I am in teaching mode, I reset the toolbars. Last week at the Excel Dashboard Boot Camp, I kept my customizations visible, and people were asking me what button I just pushed, or how I did something.

Related Posts:

• How To: Assign a Macro to a Toolbar or Menu
• Build an Excel Add-In 6 – Interface for 2003
• How To: Assign a Macro to a Button or Shape
• How To: Assign a Macro to an ActiveX Control
• AutoFilter Tricks
• A Belated Review of Excel 2007
• My First Look at Excel 2010
• Forms Controls and ActiveX Controls in Excel
• How to Edit Series Formulas
• How To: Record Your Own Macro