Changing Macro Security Settings in Excel 2007

To change macro security settings in Excel 2007, the Developer tab must be displayed on the ribbon. If the Developer tab is not displayed:

1. Click the Office button.
2. Click Excel Options
3. In the “Popular” Category, place a check mark next to “Show Developer Tab in the Ribbon” and click OK.
4. On the Developer tab, click Macro Security. In the Macro Settings category, select “Enable all macros”.
5. Click OK to exit all dialog boxes. You may need to close, then re-open Excel.