My workflow is as follows:

1) The user creates a workbook from a template (file.xlt) which has a
number of macros and userforms in various modules including the
workbook and the worksheet. He makes various changs to the new
workbook.

2) The user has his own workbook which may or may not have his own
macros.

3) The user wants to insert the worksheet created from the template
into his own workbook. If he uses move/copy sheet, the sheet gets
moved, but only the macros associated with the worksheet are moved. Any
attempt to run them fails since they refer to routines in the modules.

How can I combine the two workbooks together so that all the code
modules move from my workbook into his workbook?

Thanks
LRL