Configuring the Excel or Word Macro Security Settings

You can configure Excel macros to reduce the risk of jobs failing when executing Excel or Word components on Windows stations.

  1. Open a file:
    • From Excel, open a worksheet.
    • From Word, open a document.
  2. From the File menu, select Options, and then select Customize Ribbon.
  3. From the Main Tabs list, select Developer.
  4. Select OK.
  5. From the Developer tab, select Macro Security, and then select Macro Setting.
  6. From the Developer Macro Setting list, select Trust access to the VBA project object model.
  7. Close Excel or Word.