If you plan to work with VBA macros, you'll want to make sure that the Developer tab is displayed in Excel. To display this tab
Choose Office Excel Options.
In the Excel Options dialog box, select Popular.
Place a checkmark next to Show Developer tab in the Ribbon.
Figure 22-1 shows how the Ribbon looks when the Developer tab is selected.
Figure 22-1: The Developer tab, which is not displayed by default, contains commands that are useful for VBA users.