Customizing Ribbon Buttons for Excel 2007 Dashboards

Excel Dashboard Update:

Here are some recent pointers to resources that are very helpful to excel dashboard builders and users.

This is an excel sales dashboard template for you to download and reuse:

Sales Dashboard in Excel

This is a video on excel reporting and how a dashboard view can enhance excel reports:

This is the link for future info on these excel management reports:

Building a dashboard with Excel 2007? Don’t forget to make use of the Excel 2007 ribbon. You can add your own custom tabs and buttons to the Excel ribbon using XML or RibbonX code. Thanks to Mike Alexander, author of Excel 2007 Dashboards & Reports For Dummies, there is a freeware Custom Button Builder for Excel 2007.

As this Excel 2007 Custom Ribbon Buttons video tutorial shows, the utility asks you to fill out a table of values and it provides a sample worksheet with your custom tabs/buttons (complete with icons and code that can call your macros).

Let’s have a look at some screenshots I captured from the video:

You can select from the billions of icons on your machine:

Excel 2007 Ribbon Icons - Datapig utility

Click to see more of this Excel 2007 Ribbon Customization utility:

Continue reading