Sunday, 14 October 2018

Change Macro Settings

To use Excel Add-In, you need to set the Excel's Macro Settings to "Disable all macros except digitally signed macros". If your Macro Settings is set at "Disable all macros without notification" or "Disable all macros with notification", you will not be able to use any function in Excel Add-In.

Here are the simple 5 steps to change Macro Settings:
  1. Click Excel's "File" menu tab.
  2. Click "Options" at Excel's Backstage View

  3. Select Options of Backstage View
    Backstage View of Excel. Select "Options"

  4. Click "Trust Center", then "Trust Center Settings..."

  5. Click Trust Center Settings...
    Click "Trust Center" and then "Trust Center Settings..."

  6. Click "Macro Settings", then select "Disable all macros except digitally signed macros"
  7. "Disable all macros except digitally signed macros"
    Select "Disable all macros except digitally signed macros" and click OK.
  8. Click OK

Other Resources

  1. More resources on changing Macro Settings.
  2. Go back to Installation (of Excel Add-In) Help Page.