By default, the Developer Tab is not displayed as a menu option in Excel when you first open it up. You can, however, add it by following the few steps below.
Adding the Developer Tab to your Ribbon menu allows you to:
Write macros and VBA (Visual Basic for Applications) code.
Run macros that you previously recorded.
Use XML commands.
Use ActiveX controls.
Create applications to use with Microsoft Office programs.
Use form controls in Microsoft Excel.
Step 1 Click the File tab and then click Options
Step 2 Click Customize Ribbon.
Step 3 Under Customize the Ribbon and under Main Tabs, select the Developer check box and then click OK.
The Developer Tab will now show in the Ribbon Menu for you and will continue to show in Excel until you either reverse the instructions below or you reinstall Excel on your computer.
