Kornilios Ampatzis/ July 26, 2019/ Tutorials/ 0 comments

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.

Share this Post

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>