Possible to execute a macro dynamically?

Yes there is and I use this method myself for exactly the use case you mention.

The great @gglick showed us the way in this post:

2 Likes