Hi Brock,
Each command button will need its own macro, but all this will need is code to call the larger macro to do the real work. For example:
Code:
Private Sub CmdDoAction1_Click()
Call MySub
End Sub
If you know how many of these could potentially be needed, you could simply build your code with them ahead of time. They'll remain dormant until the corresponding command button gets created.