If Developer tab did not show on menu bar, follow steps on image#1 , else, follow steps on image#2
1-Click file
2-Click Customize ribbon
3-Check the Developer check box
4-click OK
image#1
1-Click on developer tab
2-Click Macro security
3-Enable all macro or you can select "Disable all macros with notification".
4-Click OK
5- Important step : Re-OPEN the worksheet file.