Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Visual Basic for Applications is disabled by default in Excel 2007
Article ID: 919195 - View products that this article applies to.
Important This article contains information that shows you how to help lower security settings or how to turn off security features on a computer. You can make these changes to work around a specific problem. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this workaround in your particular environment. If you implement this workaround, take any appropriate additional steps to help protect your system.
When you use Microsoft Office Excel 2007, some features that are related to Microsoft Visual Basic for Applications (VBA) may be missing or disabled.
For example, you may experience one or more of the following symptoms:
To work around this default functionality, use the following methods as appropriate for your situation.
Method 1: Enable the content for the current workbookTo enable the macros only in the workbook that you are opening, click Enable Content. If the workbook contains unsigned macros, you will again be prompted to enable the content. If you trust the workbook and the source of the workbook, click Enable this content, and then click OK.
Note If you do not trust the workbook or do not know the source of the workbook, we recommend that you do not enable the content. Instead, click Leave this content disabled (recommended), and then click OK.
Method 2: Locate the Macro dialog boxThe Developer tab includes macro and form authoring tools and XML-related features. By default, the Developer tab is not displayed in the Ribbon. To display the Developer tab, follow these steps:
Method 3: Change the macro security settingsWarning This workaround may make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.
To change how Excel 2007 handles macros, you may want to change the security settings. Macro security settings are located in the Trust Center. However, if you work in an organization, the system administrator may have changed the default setting. Therefore, you may be prevented from changing any settings.
Note When you change the macro security settings in the Trust Center, the settings are changed only for Excel 2007. The macro security settings are not changed for all programs in the 2007 Microsoft Office system.
To change the macro security settings in Excel 2007, follow these steps: