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?