Excel Toolbars for Fun & Profit

I started a new job several years ago where the first thing they told me was that they needed a custom Excel utilities toolbar. Like any good developer, I asked them what tools they had in mind … I got a blank stare.The following toolbar is the result of many revisions.

Continue Reading: Excel Toolbars for Fun & Profit »

Programming/Customizing the Excel 2007 Ribbon Using VBA

The Office 2007 Ribbon is a huge change in the user interface from the CommandBars of Office versions 2003 and earlier. However, the VBA programmer will be pleased to learn that using .NET or Visual Studio Tools for Office (VSTO) is not a requirement to control the Ribbon programmatically. In fact, although Ribbon customization requires the use of XML, which definitely is a big change, Ribbon Extensibility ("RibbonX") is actually easier to manipulate using VBA.

Continue Reading: Programming/Customizing the Excel 2007 Ribbon Using VBA »