Thursday, July 18, 2013

How to Add DataPig Buttons to the Excel 2007 Ribbon


1. Open Microsoft Excel 2007. Select the “Office” button and “Open” from the menu. Click on the file named “Custom_UI_Builder.xlsm.” Click the “Open” button.
2. Click the drop-down arrow in column “A” located under “Tab to Use.” Select the name for the Ribbon Tab where you want the button to appear.
3. Type a name for your tab in column “D” under “Tab Name” if you selected to put the button in “My Own Custom Tab” in column “A.” Otherwise, leave this cell blank.
4. Type group name in column “E” and a button label in column “F.” Select the button size using the drop-down box in column “G.”
5. Click the “Find Image” button. Select an image from the “MSO Image Finder” window.
6. Repeat Steps 2 through 5 in each row until you’ve defined the cells for every button you want to create.
7. Click the “Output Now” button. Select the radial button next to the type of output you want. Click the “Go” button.

Blogger news