How to Access the VBA Toggle Button

Written by ty arthur
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Access the VBA Toggle Button
Accessing the VBA button lets you make custom code. (girl with a laptop image by Dmitri MIkitenko from

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


    Excel, Word or Power Point

  1. 1

    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.

  2. 2

    Click the "Popular" link in the "Categories" section at the left side of the window. Scroll to the "Top Options For Word" section.

  3. 3

    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.

  4. 4

    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.

    Microsoft Outlook

  1. 1

    Open Microsoft Outlook and click the "Tools" option at the top of the screen. Scroll down and click "Options."

  2. 2

    Navigate to the tab labelled "Other." Click the "Advanced Options" button underneath the "General" heading.

  3. 3

    Scroll down to the "Microsoft Office Programs" heading. Click "Show Developer Tab in the Ribbon" and select "OK."

    Microsoft Visio

  1. 1

    Click the "Tools" button and choose the "Options" entry.

  2. 2

    Navigate to the tab labelled "Advanced" and scroll down to the "Advanced Options" heading.

  3. 3

    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."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.