Excel VBA Macro
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.
- Obtain a digital certificate and create a digital signature
- Find digital ID or digital signature services
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 -
In the dialog, select the second tab called Security, and then select the zone called Trusted sites.
Internet Properties Security Tab Trusted sites -
Below the Zones, click the button called Sites, which will produce another window where you can add trusted sites.
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.