Error Description:
The user is getting an error while executing an Excel Macro.
Solution:
- Open the Excel file.
- Click on the File menu.
- Click on the Options button on the left-hand side section to display the Excel Options dialog.
- Click on the Trust Center field on the left-hand side section.
- Click on the Trust Center Settings… button.
- Select the Trust access to the VBA project object model check box.
- Click on the OK button.