To create and run macros and to develop in VBA, the Excel Developer Tab is used.
However, the Developer Tab is not shown by default in Excel.
It’s quite simple to show the developer tab, which is very handy when you want to really make Excel into a more amazing tool than it already is.
Follow these simple steps to enable the developer tab:
Click the File tab, then select Options.
Under Options, click Customize Ribbon, and then click the check box beside Developer under Main Tabs.
The Excel Developer tab should now be visible, as shown in the image below.
Now you can go and do some really amazing things in Excel.