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.

Enabling Visual Basic in Office and adding a Module

Now under “Customize the Ribbon” enable the checkbox before Developer.

Enabling Visual Basic in Office and adding a Module

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

Enabling Visual Basic in Office and adding a Module

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

Enabling Visual Basic in Office and adding a 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.

What's your reaction?
Solved it!
0%
Helped me
0%
Didn't work
100%
Inaccurate Information
0%
About The Author
Yuri Pustjens
Yuri Pustjens
2014, 2015, 2016, 2017 and 2018 Microsoft Most Valuable Professional Windows Yuri specializes in troubleshooting (crash analysis and devices), system resource utilisation and system performance. He is also very interested in Customer Security. Yuri can be found as Windows Community Moderator and Wiki Author on Microsoft Answers and is active on different communities all across the web.
Comments
Leave a response

Leave a Response