Enabling Visual Basic in Office and adding a Module
In this article, we will show you how to enable Visual Basic in Office and how you add a new module in your Office document, spreadsheet, powerpoint and so on.
You can skip steps if you have already done them.
Step 1. Adding the Developer tab in Office
By default the developer tab in Office is invisible. You can however easily activate it by right-clicking the ribbon and then click on Customize the Ribbon.
Now under “Customize the Ribbon” enable the checkbox before Developer.
Once done, click on OK to save the changes. You should now see the developer tab appear in the ribbon.
Step 2. Opening Visual Basic
In the ribbon click on Developer and then choose for Visual Basic
Step 3. Adding a module
Once the Visual Basic editor has opened, right-click on the document, spreadsheet or whatever project you have and choose Insert, then choose Module
You can now program you own code in the module you just added.
We hope this article helped you on how to enable developer tools, starting visual basic and adding a module in Office 2016. This guide is the same for Office 2013 and works in all office programs including Word, Excel, PowerPoint, Project and so on.