In previous versions of Excel I could make a temporary commandbar that held a control that I could "click" programmatically. Here's an example:
'Make a temporary commandbar with the button that fires the flag for followup dialog
Set TempBar = CommandBars.Add(Name:="FlagDialog")...