Microsoft Excel provides wide range of options for Excel users. Microsoft Excel allows to create the Macros and run the existing Macros in Excel. To do this, needs to display the Developer tab in Microsoft Excel.
The following steps explains how to display the Developer tab in Microsoft Excel 2007. So, once the Developer tab is displayed; we can create new macros and run the existing ones.
Step (2): Now click on Excel Options button; it will display the Excel Options dialog window.
Step (3): In Excel Options dialog, click on Popular tab which is in left pane list. It will display the most popular options in Excel.
Step (4): Now select the Show Developer tab in the Ribbon checkbox which is under Top options for working with Excel group.
Step (5): Now click on OK button to Save your changes. Now you can see the Developer tab in Microsoft Excel. When you click on Developer tab, it will display the options to run/create the macros.
by Code Steps