Excel VBA Macro

Recently additional measures have been taken by Microsoft to protect users from running macros in Excel. The warning text below may turn up on opening a downloaded xlsm file .

Security risk Microsoft has blocked Macros from running because the source is untrusted.

When the above message is displayed, it may be necessary to apply one of the below steps to enable macros.

Document Signing

A signed document may enable the macro depending on the type of certificate. When the report should be accessible by a team, the safest solution is to use a certificate from a Certificate Authority (CA). The following links provide more information on this procedure.

Internet Options

On a Windows environment, there is a settings dialog called Internet Options or Internet Properties. The below steps describe how to configure a trusted site, from which you can download xlsm files that will not be disabled.

  • Searching the menu for either will provide a control panel dialog for Internet Properties.
    Internet Options
    Internet Options
  • In the dialog, select the second tab called Security, and then select the zone called Trusted sites.
    Internet Properties
    Internet Properties
    Security Tab
    Security Tab
    Trusted sites
    Trusted sites
  • Below the Zones, click the button called Sites, which will produce another window where you can add trusted sites.
    Add trusted site
    Add trusted site
  • Enter https://<environment name>.istools.com , click Add and then click Close.

The above procedure should enable opening an Excel report from the <environment name> . It may not work on already downloaded files, but should work on files downloaded after settings have been saved.

More tips