Only a few steps are required to activate the developer tools in Office. To do this, proceed as follows:
- Start an Office application, such as Word, Excel, or PowerPoint.
- Click on “File” and then on “Options“.
- Select “Customize the Ribbon” from the left pane of the Options window.
- In the “Options” window, select “Customize the ribbon” on the left.
- Under “Main Tabs“, select “Developer Tools“.
In the right pane of the “Excel Options” or “Word Options” window, now select the “Main Tabs” item. See “Main Tabs” for a list of tabs that appear on the ribbon. From here, select the “Developer Tools” option by ticking the appropriate box.
- Click “OK” to save the settings.
After you have followed these steps, the “Developer” tab will appear in all other applications, regardless of which application you made the setting in. Here, then, you’ll find the described capabilities of developer tools, including macros, add-ins, form controls, and more.
Note: It is possible (this was the case for me) that the developer tools were strangely not displayed in Outlook, but they were in all other Office applications. I cannot say why this is so. But you can just do the previous steps again in Outlook from the options menu and then the developer tools will appear there too.
see fig. (click to enlarge)