Enabling the Developer Tab in Excel®
VBA is installed with Excel, and the VBA editor is accessible just by pressing Alt+F11 keys within Excel. To run macros directly from a sheet you need to enable the Developer tab in the Excel ribbon. In the Developer tab you will find the different control tools that can be inserted in the worksheet.
The steps below describe how to activate the Developer tab in the Excel ribbon.
1
In Excel right-click on any ribbon tab, and select Customize the Ribbon....
2
In the Excel Options window, locate the Main Tabs list and select Developer.
3
Click OK.
The Developer tab is now available in the ribbon.