Microsoft Excel 2007: How to Enable Macros

Archived Historical Data: Not Actively Maintained.

This article describes how to enable macros in Microsoft Excel 2007 spreadsheets.  To read more about what a macro is:

To Enable Macros in Excel 2007

1. Open Excel 2007 and click the Office button in the upper left corner of the screen. At the bottom of this menu, click the Excel Options button.

screenshot of step 1

2. Click the Trust Center button on the left. Then, at the bottom right, select Trust Center Settings.

screenshot of step 2

3. In the new window that appears, choose Macro Settings from the sidebar and select Disable all macros with notification from the list of options that appear. This option keeps macros disabled but notifies users when macros attempt to run, allowing users to decide on a case-by-case basis which macros to enable.

4. Click OK to exit this window.

screenshot of step 3

5. For the new settings to take effect, it will be necessary to close Excel and reopen it. A security dialog box should appear beneath the Office ribbon the next time you attempt to run a spreadsheet that contains macros.

screenshot of step 4

6. When the notification appears, click the Options button.

7. Choose Enable this content from the options that appear to allow macros to run within the current spreadsheet.

8. Click OK to close the window.

screenshot of step 5

NOTE:  If this doesn't work, try refreshing the worksheet.

Referenced from:

1/28/2014 4:09:10 PM  

We love feedback! Please help us improve this article.

Article Rating:
Email Address:
(Optional, unless you would like to hear back from us)
GROK is a resource of Louisiana State University developed and maintained with support of the LSU Student Technology Fee.  We love getting feedback from the general public, but our one on one support efforts are generally dedicated to the LSU community.  Thanks for your understanding!
"" ""

Information Technology Services
200 Frey Computing Center · Baton Rouge, LA 70803
Telephone: 225-578-3700 · Fax: 225-578-3709 · E-mail:

Copyright © 2006. All Rights Reserved. Official Webpage of Louisiana State University.