20:20 Innovation logo
Login

Home / Important Information

Downloading Resources

Please ensure every time you wish to use one of the resources, you revisit the 20:20 Innovation website and download the latest version of the resource. This will ensure that you are always using the latest template and are aware of any updated guidance on the resource.

Macros Security Guidance Notes

In 2022, Microsoft released a new version of Microsoft Excel that brought in advanced security protection against Excel Macros. In their aim to safeguard users from malicious macros, Microsoft made the security so tight that users now across an error message saying Security Risk – Microsoft has blocked macros from running because the source of this file is untrusted.

In simple words, the Microsoft change blocked the macros on files downloaded from the internet. As a number of the 2020 spreadsheets and resources contain Macros, and you will need to review and follow the procedures below to ensure they work effectively.

Macro - Security Risk – Microsoft has blocked Macros from Running

Some users when they download Excel resources will get the error message below saying Microsoft has blocked macros from running because the source of this file is untrusted when trying to run macros downloaded from the internet.

When you click on the Learn More button, it redirects you to the Microsoft website that tells you in-depth about why you are seeing this error and also provides you with the solution.

You have the choice of Unblocking a single file or Unblock all files from a specific network share or website.

Unblock all files from a specific network share or website.

We suggest you follow the instructions to Unblock all files from a specific network share or website so you have full access to the suite of 2020 resources available to you. Please follow the steps outlined on Microsoft support page, scroll half way down the page to the Unblock all files from a specific network share or website section.

  1. Tap the start button or Windows key and type Internet Options.
  2. Select Internet Options from the search results and the Internet Properties dialog box will appear.
  3. On the Security tab, select Trusted Sites, then select Sites.
  4. Type the URL of the site below or server that contains the Microsoft 365 files with the macros you want to run, and then select Add.
  5. URL > https://www.2020Innovation.com
  6. Select Close and then OK.

Unblocking a single file

For an individual file, such as a file downloaded from an internet location or an email attachment the user has saved to their local device, the simplest way to unblock macros is:

  1. Close the workbook.
  2. Right-click on the workbook.
  3. Select Properties.
  4. Under the General tab, make sure to check the Unblock box in Security.
  5. Select the Apply button.
  6. Now open the workbook.

Macro Security Warning

Some users may see a Macro SECURITY WARNING when opening some of the Excel resources, as shown in the figure below. If you see the message below, simply select the Enable Content button to permit use of the macro within the Excel document.

If you wish to change your Macro settings, please see the procedures outlined on the Microsoft website.

Please speak to your companies system administrator who can help amend these settings. By way of example, at 20:20 Innovation, we use the setting settings to “Disable all macros with notification” this means that by default macros are disabled, but security alerts appear (as per figure above) if there are macros present.