Enable macros in Excel 2007

Access to enabling macros in Excel 2007 is under the Developer tab. The default settings, however, do not show the Developer tab in the Ribbon.
How to show Developer tab in the Ribbon if it is not showing?

Step 1 – Click on Excel Options



Step 2 – Check box next to Show Developer tab in the Ribbon then click OK.



Now Developer tab will be showing in your Excel Ribbon as shown below.



Step 1 – Click Macro Security, select Disable all macros with notification then click OK.



Step 2 – Save the workbook, close it then reopen it. Click on Options shown below to enable the content.



Step 3 – Check the bubble next to Enable this content then click OK.



Now macros are enabled in your workbook!