Hello,
The Static HTML web part uses WYSIWYG editor that process its input. However if you place your macro in the Source mode and Save the content, it should get resolved correctly on the live site (no matter how it gets rendered in the editor).
I would recommend to use the Static text web part instead, that is the source of the HTML by default.
Best regards,
Jan Hermann