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

"Gord Dibben" wrote:

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

On Fri, 3 Apr 2009 05:47:01 -0700, Kersten
wrote:

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

"Don Guillett" wrote:

IF?? the macro will work in the sheet module then just copy the sheet

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kersten" wrote in message
...
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?