Macros can add a wide variety of custom behavior to Microsoft Excel workbooks, but they also pose a potential security risk. Consequently, each version of Excel has provided ways for users to enable or disable macros by setting the desired level of macro security from Very High to Low; the initial “default” setting provides a relatively high level of protection.
We have provided several custom operations in the Option B Excel eForms for your convenience. These function all require that macros be enabled. Before you can enable macros, you must set the appropriate macro security level.
The process for enabling macros depends upon the version of Excel and whether the workbook has been digitally signed.
When an Option B workbook is opened, a macro runs that reads some identity information from the Registration form and hides the red “Macros are disabled” warning in the header area of the spreadsheet. In Excel 2010 only (not in other versions of Excel), this macro runs only if Excel is already running when you open the workbook.
Therefore for Excel 2010, we strongly recommend that you start Excel 2010 before opening an Option B workbook.