Versions Compared

Key

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

Include Page
OB61:Enabling Macros in Excel
OB61:Enabling Macros in Excel

Show If
groupconfluence-users

The content on this page is hidden so that anonymous users don't see it if the page is returned in a search.  Anonymous users are redirected to the PRL Text File Specifications.

Hide If
groupconfluence-users

Redirect
delay2
locationhttp://sbdocs.psur.cornell.edu/display/OB60/Enabling+Macros+in+Excel

...

hiddentrue

Background

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.

 

...

titleExcel 2000 - 2003...

...

titleTo change the macro security level...

...

titleTo enable macros in the Option B workbooks...

With macro security set to either High or Medium:

...

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 publisherunchecked and select Enable Macros. This approach enables 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.

...

titleExcel 2007...

...

titleTo change the macro security level...

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

...

titleTo enable macros in the Option B workbooks...

...

titleExcel 2010 and 2013...

...

titleTo change the macro security level...

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

...

titleTo enable macros in the Option B workbooks...

...

Excel 2000 - 2003

To change the macro security level

Excel 2000 through Excel 2003 have four macro security levels.

...

To enable macros in the Option B workbooks

With macro security set to either High or Medium:

...

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 publisherunchecked and select Enable Macros. This approach enables 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.

Excel 2007

To change the macro security level

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

...

To enable macros in the Option B workbooks

...

Excel 2010 - 2013

To change the macro security level

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

...

To enable macros in the Option B workbooks

...

 

 

...

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 other versions of Excel), this macro runs only if Excel is already running when you open the workbook.

...