Page History

Excel 2000 through Excel 2003 have four macro security levels.

To change the macro security level

1. Start Excel.
2. On the Tools menu, point to Macro and click Security.
3. In the Security dialog box, click the Security Level tab.
4. Select the desired macro security setting and then click OK. (Use either Medium or High for Option B.)
5. Close Excel. (The security-level changes will not take effect until Excel is restarted).

To enable macros in the Option B workbooks

With macro security set to either High or Medium:

1. 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.

2. Choose the type of form and open a Blank Form or reopen a previously saved Existing Form.
   
   
3. When Excel 2000 (or 2002, 2003) starts, you will be presented with a Security Warning dialog box. It should indicate that the workbook contains macros by Cornell University.
• If macro security is set to High, you may only enable macros from trusted publishers. The Enable Macros button is disabled until you check “Always trust macros from this publisher”. Check the box, then select Enable Macros.
  
  

• If macro security is set to Medium, you have two choices:

  • Recommended: Check “Always trust macros from this publisher”, then select Enable Macros.
  • Leave “Always trust macros from this publisher” unchecked and select Enable Macros This approach enable macros only for this workbook and only for this session. You will need to enable macros every time you open an Option B workbook.

   

  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.