Copy Macro with Worksheet

[Kersten]

I have a template that contains many worksheets. Within the project I have a
macro. The users of th etemplate create copies of individual worksheets and
move them to another destination. Is there a way to automatically copy the
macro so that it becomes part of the new project as well as keeping it in the
old one?

 

[Kersten]

It doesn't work. I am using a barcode macro. It works perfectly from the
original template where I loaded teh macro but when I move and create a copy
of the worksheet the macro is not there and the barcode does not work

 

[Gord Dibben]

If the macro is stored in a general module of the Template, copying sheets
will not move the macro.

You could save the workbook created by opening the Template then delete
sheets you don't need from that saved workbook.


Gord Dibben MS Excel MVP

 

[Kersten]

What I ended up doing is creating a Macro template and moving the worksheets
into it before saving it as my final product
Thanks for your help