Enable trust access to the VBA project object model

Trust access to the VBA project object model is required for IBM® Planning Analytics for Microsoft Excel. Macros developed for IBM Planning Analytics for Microsoft Excel may not work properly if trust access to the VBA project object model is not granted.

1. Start Microsoft Excel.
2. Open a workbook.
3. Click File and then Options.
4. In the navigation pane, select Trust Center.
5. Click Trust Center Settings....
6. In the navigation pane, select Macro Settings.
7. Ensure that Trust access to the VBA project object model is checked.
8. Click OK.

Results

Trust access to the VBA project object model will be granted for IBM Planning Analytics for Microsoft Excel.