|
The folks at Microsoft certainly made Excel 2007 more powerful, but on the flip side, some of the customization abilities that VBA programmers love have disappeared, namely, custom toolbars and custom menu bars. But don’t fret: If you create a macro that you use frequently, you can add a new button to the Quick Access Toolbar (QAT). Doing so is easy, but you must do it manually. Here’s how: Right-click the QAT and select Customize Quick Access Toolbar to display the Customize tab of the Excel Options dialog box. In the drop-down box labeled Choose Commands From, select Macros. Select your macro from the list. Click the Add button, and the macro is added to the QAT list on the right. If you like, click the Modify button to change the icon and (optionally) the display name.
Unfortunately, the new QAT button only works when the workbook that contains the macro is open. Even worse, the macro works only when that workbook is the active workbook. In order to run a macro from the QAT when any workbook is active, store the macro in your Personal Macro Workbook.
|
