How to enable macro.

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.

image#2