What? No one has answered?
Go to the VBE (Alt F11).
Create a Macro called Main. Assign it to your Ctrl+Shift+(?). Here is the code:
Sub Main()
Macro1
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
End Sub
This assumes you’ve used the Macro Recorder and let it automatically name each macro. If you named the macros something else – just substitute that name for Macro#.
I hope this helps. Since you’re into Excel reports, you might want to check out my blog: Beyond Excel
Discuss This Question: