Office Office 2013 Office 2016 Office Tutorials

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.

Leave a Reply

Your email address will not be published. Required fields are marked *