Taking Macros into other workbooks

[Maui]

I have a macro that takes 6 worksheets to another tab and saves them as a file name.

Within one of these tabs is a button that should connect to a print macro. when I move the tabs into new workbook the macro is lost as it is in the orginal workbook. This newly saved workbook is to be emailled so I need a way of getting the macro in the new workbook.


I am sure this is possible I just dont know how to do it.



Any ideas


Thansk in advance


Maui

 

[tony0682]

Open the macro on the old one.. Copy the code and create a new macro in the new one and paste it.

 

[Maui]

Can this be done in recorder so it stays there. I want it to be seemless.