Sunday, March 25, 2012

How to Create Macro Buttons in Excel 2007


1. Open an Excel workbook that contains a macro.
2. Click the arrow to the right of the Quick Access Toolbar to reveal a drop-down menu; from that menu choose 'More Commands....'
3. Click the left-hand drop-down menu in the resulting window. Choose 'Macros.'
4. Double-click a macro in the resulting list to move it into the 'Customize Quick Access Toolbar' list.
5. Click the 'Modify' button below the list of Quick Access Toolbar buttons.
6. Choose a button image in the resulting window, and type a new display name for the button, if you want. The button name appears in a tooltip when you hover the mouse cursor over the button.
7. Click 'OK' to close the Modify Button window, then 'OK' to close the Excel Options window and return to the main Excel window, where your macro button appears on the Quick Access Toolbar.

Blogger news