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. The process for enabling macros depends upon the version of Excel and whether the workbook has been digitally signed.
Excel 2000 through Excel 2003 have four macro security levels.
To change the macro security level
To enable macros in the Option B workbooks
With macro security set to either High or Medium: