Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


titleExcel 2010...

Beginning with Excel 2007, there are still four security levels but their meanings are subtly different from those in Excel 2003 and earlier.

To change the macro security level

  1. Start Excel.
  2. Open the File menu.
  3. Select the Options button.
  4. In the left pane of the Excel Options dialog, select Trust Center.
  5. Click the Trust Center Settings button in the right pane.
  6. In the left pane of the Trust Center dialog, select Macro Settings.
  7. In the right pane, select the desired macro security setting. (Use either of the middle two settings; it does not matter for Option B.)
  8. Click OK to close the Trust Center; click OK to close Excel Options.

To enable macros in the Option B workbooks

  1. Start the Option B program.


    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. If you have not previously selected “Trust all documents from this publisher” with an Option B file, the workbook will open with macros disabled and a Security Warning bar between the Ribbon and the spreadsheet.
    • Click the “Macros have been disabled” text next to the Enable Content button (but NOT 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.


      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.

  4. The Microsoft Office Security Options dialog appears showing information about the digital signature for this form. The digital signature should be valid, but may have expired; the macros should be signed by Cornell University. You have two options:
    • Recommended: Select “Trust all documents from this publisher”. (Not available if the signature has expired.) From now on, all Option B workbooks should open with macros enabled.
    • Select “Enable this content”. You will need to enable macros the same way every time you open an Option B workbook.

  5. Select OK to close the Security Options dialog.


titleImportant Note for Excel 2010

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