- Excel Book Excerpt
Excel Where Are My Macros?
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Where Are My Macros?
Problem: Did Microsoft abandon the macro facility? Where are the buttons to record a new macro, run a macro, and so on? How do I get to the Visual Basic Editor?
Strategy: Most of the macro icons are hidden. Due to beta tester outcry, Microsoft reluctantly added three macro options to the extreme right end of the View tab. You use the Macros dropdown to view macros, record a macro, or use relative references while recording a macro.
Figure 5 A subset of macro commands are available on the View tab.
To access the rest of the macro functionality, you need to enable a hidden Developer ribbon tab. In Excel 2007, choose Office Icon, Excel Options, Popular, Show Developer Tab in the Ribbon. In Excel 2010, choose File, Options, Customize Ribbon. Add a checkmark next to Developer.
The Developer tab offers macro commands, buttons from the former Forms toolbar and Control Toolbox, and XML settings.
Figure 6 Microsoft disabled the Developer tab by default.
Figure 7 If you use macros, enable the Developer tab.
Additional Details: When you are recording a macro, instead of seeing the Stop Recording icon floating above the Excel window, you now see it in the Status Bar, next to Ready.
Figure 8 Once you’ve recorded a macro, the Stop and Record buttons will appear next to Ready.
The same area of the status bar includes a Record Macro button when you are not recording a macro. However, because there is not a Relative References button, you cannot effectively record macros without using either the View tab or the Developer tab of the ribbon.
For more resources for Microsoft Excel: