Copy vba module from one workbook to another

I need a macro to copy...call it Module 1...from an open workbook named "MRO Induction Form (Blank)" to another workbook. "MRO Induction Form (Blank)" contains a page named "Induction Form" which I rename to "Induction Form (2) and then move that page to create a second work book. Unfortunately, the macro does not move with it. At this point in the process, the second workbook has yet to be named.

Another way to approach this is to copy "Module 1" when I "move" Induction Form (2).

Any help will be appreciated

Hi

Save the macros in your personal.xl.

http://office.microsoft.com/en-us/ex...102174076.aspx


hope this helps!

Sbidgol,

I like this approach but the macro in this workbook must be used by numerous users. Is there a way to share the macro other than in the personal.xl?