The programs contained in the Microsoft Office suite include an option for programming your own code through the Visual Basic for Applications (VBA) programming language. To access the VBA buttons and start coding, you first need to turn on the "Developer" tab in the program's main toolbar. Toggling the Developer tab on and off is done slightly differently depending on which specific Microsoft program you are using, such as Excel or Outlook.
- Skill level:
- Moderately Easy
Other People Are Reading
Click the Microsoft Office button at the top-left corner of the window. Click the "Options" button at the bottom of the menu. For example, in Microsoft Word, click "Word Options" and so on.
Click the "Popular" link in the "Categories" section at the left side of the window. Scroll to the "Top Options For Word" section.
Click the check box labelled "Show Developer Tab In The Ribbon." Click "OK" to save the change and show the VBA buttons on the developer tab.
Click the "Developer" tab, which is located to the right of the "View" tab. Click "Visual Basic" to bring up the VBA editor screen or click "Macro" to bring up a list of previously created VBA programs.
Excel, Word or Power Point
Open Microsoft Outlook and click the "Tools" option at the top of the screen. Scroll down and click "Options."
Navigate to the tab labelled "Other." Click the "Advanced Options" button underneath the "General" heading.
Scroll down to the "Microsoft Office Programs" heading. Click "Show Developer Tab in the Ribbon" and select "OK."
Click the "Tools" button and choose the "Options" entry.
Navigate to the tab labelled "Advanced" and scroll down to the "Advanced Options" heading.
Click the check box labelled "Run in developer mode." Click "OK" to save the change.
Tips and warnings
- Remove the check mark from the "Show Developer Tab in the Ribbon" or "Run in Developer Mode" check box and click "OK" to turn the VBA options off.
- Microsoft Excel also allows you to record macros through the developer tab. Click the "Record Macro" button in the "Code" section of the "Developer" tab. Perform the actions you want to record as a macro and then click "Stop Recording."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for