Getting error while running macros in AA

I am trying to run macros in AA but getting error "The macro may not be available in this workbook or all macros maybe disabled". But I have enabled all the macros still getting error

1.- Your macro has to be in a module in vba.
2.- It has to be saved as .xlsm.
3.- Have all macros enabled.

If you have another question, I will gladly answer you.

Jaime Barba
i think problem in macro.
if you modify the macro source code and delete the Excel close code.
so close excel file on the AA.

good luck !