Customizing Ribbon Buttons for Excel 2007 Dashboards
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
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:
Click to see more of this Excel 2007 Ribbon Customization utility:
You fill out this table for each item that you wish to appear on the ribbon:
You can output either raw XML or a sample worksheet.
Here is the result – a new tab and buttons for Excel 2007:
You would tie your button to a macro:
Visit the datapig site for further details.
Tags: Excel 2007 Ribbon Customization, Excel 2007 Dashboards, DataPig Technologies Excel 2007 Utility, Michael Alexander, Microsoft Excel 2007 Ribbon Custom Buttons
Related Business Intelligence Dashboard Examples:
Are less dashboards being built using Excel 2007 than I thought? The recent post about customizi ...
A Dashboard Spy reader wrote me to ask about adding comments to his Excel worksheets so that his ...
Latest News in Excel Dashboards: New functionality for Excel based Enterprise Dashboards. One o ...
excelente