A macro can run a different macro by using a "Call" line. If you want to
run several macros with one shortcut, this method is fine. It is
particularly useful for just 2 macros. There is a variation on this method
for any number of macros which is probably easier to do. This is best
explained by an example. Let's assume that you have 4 macros with the names
MyMacro1, MyMacro2, MyMacro3, and MyMacro4. Just write a new macro, using
any name you want, e.g.,

Sub RunAllMyMacros()
Call MyMacro1
Call MyMacro2
Call MyMacro3
Call MyMacro4
End Sub

All macros must be in the same VBE module, such as the "NewMacros" module.
The macros need not be in any special sequence in the module; the call
method will find the macro it is looking for. Assign a shortcut to
RunAllMyMacros. When you press the shortcut, all macros will be executed in
the order shown in RunAllMyMacros.