How To Enable Macros In Microsoft Excel – SlashGear

You won’t see the Developer tab in Excel by default, though depending on whether or not you share the software with anyone else (and what they may have set up previously), there’s a chance you won’t have to take this step. But if you open Excel and don’t see the Developer tab in the ribbon at the top of the window, follow these steps:

1. In Windows: Click on File in the menu at the top of the screen and select Options from the drop-down menu.
2. Select Customize Ribbon, then find the Main Tabs section.
3. Click the check box next to Developer to turn on the Developer tab.
4. In macOS: Click Excel in the menu at the top of the screen, then select Preferences from the drop-down menu.
5. Choose Ribbon & Toolbar, then find the Main Tabs section and look for the Customize the Ribbon category.
6. Click the check box next to Developer to turn the Developer tab on, then click Save.

Double-check the ribbon to make sure the Developer tab is showing up, and if so, you’re ready to start creating (and running) your own macros. Also, be aware that the Developer tab will always be displayed in the ribbon from now on unless you either go back into Options and turn it off or re-install Excel.