Not with macros alone. An add-in can register for the document-open event and respond, but a macro is not loaded and waiting for the event unless the user has already launched it. So an add-in is necessary for this.
A long time ago, MindManager defined a macro that would run at application start-up but I have not checked for years whether this is still supported.
You can use macros with the Generic Smart Map Part. This defines a set of macros that are called when a smart map part is deployed in the map, refreshed or converted to a regular topic.