How do I enable macros in Excel 2010?


When opening an Excel workbook or creating a new workbook from a template, macros may be disabled depending on your macro security settings in Excel.  This may disable certain functionality of the workbook.


This article is not intended to provide complete information on the topic of Excel macro security or to provide a definitive answer for your specific security needs.  For a more thorough understanding of macro security in Excel, we recommend reading the following topic on the Microsoft Office website: Change Macro Security Settings In Excel

Most users of Office Connector find that the following steps meet their Excel macro security needs:

  1. Start Excel and click the File tab
  2. Click Options
  3. Click Trust Center and then click Trust Center Settings (show me)
  4. Click Macro Settings
  5. Click Disable all macros with notification (show me)
  6. Click OK
  7. Click OK
  8. Open your workbook
  9. The Security Warning bar will be displayed just below the ribbon.  Click Enable Content.