Enable Trust Access to VBA Projects

This topic describes how to ensure that Microsoft Excel can run the Visual Basic macros in the workbooks and add-ins when the security is properly set. Trusting access to the VBA project object model enables the add-ins to function properly.

To enable Trust access to the VBA project,

1. In Microsoft Excel, select File > Options. The Excel Options window appears.
2. Select Trust Center > Trust Center Settings. The Trust Center window appears.
3. Select Macro Settings and enable Trust access to the VBA project object model.
4. Select OK. Trust access is enabled for the VBA project object model.