The only thing that is bannable about macro is if it's botting. I made a botting macro to kill a boss over and over and pick up legendaries. It didn't ban me, but if you use it for a month or two, you will surely be banned. A simple macro like this is not even considered against Blizzards ToS.