Trusting access to the VBA project model

Overview

Compile errors can occur during publish as some worksheets contains code. The publishing process can remove this code but only if the option to trust access to the VBA project model is turned on.

Trusting access to the VBA project model in Excel 2013

Trust access to the VBA project model in Excel 2013

To trust access to the VBA project model in Excel 2013, follow these steps.

1. Start Excel;
2. Click on the File button and select Options;
3. Select Trust Center in the list on the left-hand side;
4. Click the Trust Center Settings button;
5. Select Macro Settings in the list on the left-hand side;
6. Tick the Trust Access to the VBA project object mode;
7. Click OK and close on all dialogues;
8. Close Excel;
9. Start and use BudgetLink.

Trusting access to the VBA project model in Excel 2010

Trust access to the VBA project model in Excel 2010

To trust access to the VBA project model in Excel 2013, follow these steps.

1. Start Excel;
2. Click on the File button and select Options;
3. Select Trust Center in the list on the left-hand side;
4. Click the Trust Center Settings button;
5. Select Macro Settings in the list on the left-hand side;
6. Tick the Trust Access to the VBA project object mode;
7. Click OK and close on all dialogues;
8. Close Excel;
9. Start and use BudgetLink.

Trusting access to the VBA project model in Excel 2007

Trust access to the VBA project model in Excel 2007

To trust access to the VBA project model in Excel 2007 , follow these steps.

1. Start Excel;
2. Click on the Office button and select Excel Options;
3. Select Trust Center in the list on the left-hand side;
4. Click the Trust Center Settings button;
5. Select Macro Settings in the list on the left-hand side;
6. Tick the Trust Access to the VBA project object mode;
7. Click OK and close on all dialogues;
8. Close Excel;
9. Start and use BudgetLink.

Related Topics

• Troubleshooting Publish Problems