Here’s a question we got from a reader:
I am trying to figure out macro development from going through code examples in your website. I figured out that some of the examples point out to the developer menu in Microsoft Excel, Word and Outlook. For some reason, i don’t see that menu item in the Ribbon. Am i missing out something? Is there any specific setting or configuration to make the Developer tab visible?
Thanks for the good question.
As we explained in the past, the simplest way to automate tasks in Microsoft Office applications (Excel, Word, PowerPoint, Outlook, Visio, Access and Outlook) is using Macros. Depending on which application you want to automate, you can either record or write your Macro.
Recording macros might be good for starters, but most probably you will be using Visual Basic for Applications (VBA) to write your custom Macros.
Getting started with Excel Macros is relatively simple as Excel ships a built-in Macro recorder that allows you to capture a specific sequence of actions and re-use them later on. Same for Microsoft Word.
Outlook and PowerPoint do not offer the macro recorder so you’ll need to develop some VBA chops if you want to automate tasks in your presentation or a mail message.
Adding the Developer menu to the Ribbon
Here is how we setup the macro VBA development in Excel, Word, Outlook and other Office apps:
- First off, open your Office application. In this walk through i have focused on Excel, but the process for the other apps is quite similar.
- Place your mouse on the Ribbon and hit your mouse right click menu.
- Then go ahead and hit Customize the Ribbon.
- Next, go ahead and check the Developer entry in the right hand side column, as shown below.
- You might at this point choose to show or hide the different sections of the Developer tab (Code, Addins, XML etc’). Leave those checked (visible) if you are a relatively newcomer into Macro development.
- Once done hit OK.
- Your development environment is pretty much ready. Time to get started with your coding 🙂
Showing the Developer tab in macOS
If you are on MAC and would like to go ahead and access your development environment, proceed as following:
- Open the relevant Microsoft Office application, be it Word, PowerPoint or Excel.
- In the upper command bar, hit Tools
- Then go ahead and select Macros
- Now you’ll have couple options:
- Hit Macros… in order to access your presentation/workbook or document macros.
- Hit Development, to access the VBA editor
Note: Currently (Office 365), Outlook for macOS still doesn’t support Macro development.