@Frankb posted a good alternative to using AppleScript.
But in addition to that, make sure that the macro you are creating is in a macro group that is active and enabled. Active generally means it’s not limited to any particular application or window, and enabled generally means the macro group is not disabled, nor is the macro itself disabled (greyed out).
Beyond that, if possible, post the macro itself so we can take a look at it and see what might be going wrong. As one of the moderators likes to say, "If we're not testing we're guessing, and guessing often wastes people's valuable time". 
If you need help on how to post the macro, just let us know and we can walk you through it.
If you haven’t had the opportunity to read this tutorial, I highly recommend it. It will help you get the most help for your question.
Tip: How Do I Get The Best Answer in the Shortest Time?
-Chris