- During the Office Setup process, you can choose not to install VBA.
- During the Office Setup process, you can choose to install VBA together with Office and then disable VBA.
If you choose to install VBA together with Office and then disable VBA, you can disable VBA by using system policies. If you use system policies on a computer that has multiple users, you can select which users have VBA functionality.
For more information about how to disable VBA, click the following article number to view the article in the Microsoft Knowledge Base:
Disabling VBA for Office can have far-reaching implications. Some of these include the following:
- You cannot install Microsoft Access.
- You cannot create or run VBA macros in any Office program.
- You cannot create or run Microsoft Excel 4.0 Macro Language (XLM) macros in Excel.
- You cannot use ActiveX controls in Office documents because these controls are disabled. Note that this includes Forms 2.0 controls.
- You cannot use some wizards. When you try to use an affected wizard, you receive a message that is similar to the following:C:\Program Files\Microsoft Office\Templates\1033\wizard name.wiz contains macros. Macro language support is disabled in this application. Would you like to open a copy of this document with the macros removed?Note wizard name is the file name of the wizard that you are trying to use.
- You cannot use non-compiled add-ins because these add-ins are disabled. Note that this includes certain add-ins that are included with Office, such as the Analysis ToolPak for Excel.
Note For more information about Office features that are unavailable when VBA is disabled, see the "References" section.
Article ID: 287567 - Last Review: Mar 23, 2009 - Revision: 1