In this lecture we will show how we can copy macros from one workbook to another.
We have 2 open workbooks. The TEST4U_new workbook is currently visible.
We go to the VIEW tab of the ribbon and click on View Macros.
There we click on Edit. Here we can see all the macros of the current workbook, which are inside Module 1.
The other open Workbook has no modules folder, which means no macros.
We drag Module 1 from one workbook to the other.
We can see that the modules folder has been created and the Module 1 file has been copied into it.
That was it. The macros have been copied.