Option A Getting Started Guide
Option B Getting Started Guide
...
Include Page |
---|
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.
...
title | Excel 2000 - 2003... |
---|
Excel 2000 through Excel 2003 have four macro security levels.
With macro security set to either High or Medium:
...
Start the Option B program.
Note |
---|
If this is the first time you have used the program, you will need to fill in some identifying and contact information on the registration form. |
...
|
...
If macro security is set to Medium, you have two choices:
Tip |
---|
If you check “Always trust macros from this publisher”,you only need to do this once; from then on, all Option B forms should open with macros enabled. |
...
title | Excel 2007... |
---|
Beginning with Excel 2007, there are still four security levels but their meanings are subtly different from those in Excel 2003 and earlier.
...
Start the Option B program.
Note |
---|
If this is the first time you have used the program, you will need to fill in some identifying and contact information on the registration form. |
...
...
title | Excel 2010... |
---|
Beginning with Excel 2007, there are still four security levels but their meanings are subtly different from those in Excel 2003 and earlier.
...
Start the Option B program.
Note |
---|
If this is the first time you have used the program, you will need to fill in some identifying and contact information on the registration form. |
...
Click the “Macros have been disabled” text next to the Enable Content button (but NOT the button itself) or open Info from the File menu. In the Security Warning section of the Info screen, click the Enable Content drop-down button. Choose Advanced Options.
Warning |
---|
Do Not select the “Enable Content” button in the Security Warning bar; that will enable macros only for this document. You will have to re-enable the macros each time you create a new form using Option B. |
...