Excel Macro Security

  Macro Security

Most of our products use Excel Visual Basic for Applications (VBA).

VBA is a programming language that allows developers to enhance and automate various procedures within Excel.

When you open an Excel file that uses VBA you will be prompted with a dialog box that warns you of this fact. You will then be offered the opportunity to either allow or disallow this feature.

To use our products you must ALLOW this feature. 

How do I allow Excel VBA files to run on my system?

This depends on the version of Excel you are using. Use the guide below to ensure that you correctly enable VBA when you use our Spreadsheets. 

Excel 2010 and 2013

When you open a file in Excel 2010 or 2013 that contains VBA a Security Warning will be displayed as shown below.

Security Warning – Some active content has been disabled. Click for more details.

All you need to do is click the ‘Enable Content’ button alongside the warning.

  

Excel 2007

When you open a file in Excel 2007 that contains VBA, a Security Warning will be displayed as shown below:

Security Warning – Some active content has been disabled.

Click the ‘Options’ button,  then click  ‘Enable this content’  and finally click OK.

Excel 2003

When you open a file in Excel 2003 that contains VBA a Security Warning will be displayed as shown below.

Security Warning – File xxxx contains Macros.

Just click the ‘Enable Macros’ option.