Hi Vishu,

Whether to use msgbox's between macros is up to you, it depends on what
you are trying to do and what reasons you may need to stop the macros
for.

To link them do the following:

Before the End Sub in Macro1 put the following:

If Msgbox("Would you like Macro2 to now run?", VBYesNo,"Macro2") =
VbYes then
Call Macro2
Endif

You will need to replace Macro2 with what ever you have called it etc.
You can put the same at the bottom of Macro2 changing the name of
Macro2 to Macro3 etc.

Regards,

James