FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Open both the workbook that contains the macro you want to copy, and the workbook where you want to copy it. On the Developer tab, click Visual Basic to open the Visual Basic Editor., or press CTRL+R . In the Project Explorer pane, drag the module containing the macro you want to copy to the destination workbook.

Detailed explanation-2: -Just type the word Call then space, then type the name of the macro to be called (run). The example below shows how to call Macro2 from Macro1. It’s important to note that the two macros DO NOT run at the same time. Once the Call line is hit, Macro2 will be run completely to the end.