Each account has a directory in the WTF folder that contains a macro-cache file that holds the macros. Not sure when/how that gets updated from the server.