This could probably be done with a custom addon, but I'm pretty sure you can't do that with macros. I'm not an expert on either though.