Whenever I have a workbook and insert a new sheet from the template with
the macros, the macros never come with the template to the new
workbook.

Is there something I have to do differently?


--
reddog9069
------------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...o&userid=24458
View this thread: http://www.excelforum.com/showthread...hreadid=388166

When you add the sheet, the macros behind that sheet (in the template) should
show up.

But the code in general modules won't come along for the ride.

One way around it is to keep the macros as text files and import those text
files (or to open the template workbook, export the modules and then reimport
them into your new project).

Chip Pearson has some code that shows how to do this:
http://www.cpearson.com/excel/vbe.htm

reddog9069 wrote:

Whenever I have a workbook and insert a new sheet from the template with
the macros, the macros never come with the template to the new
workbook.

Is there something I have to do differently?

--
reddog9069
------------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...o&userid=24458
View this thread: http://www.excelforum.com/showthread...hreadid=388166

--

Dave Peterson

Thanks for the response-

When you add the sheet, the macros behind that sheet (in the template)
should show up.

I have macros assigned to buttons. This is a button that is actually
on the worksheet, not a toolbar button. They do not work.
My template is named Subtask.xlt and lets say I have a workbook called
test.xls.

When I right click on one of the tabs at the bottom then click
Insert...
I select Subtask.xlt and it gives me the warning that this sheet
contains macros and I enable macros.

When I hit the button that the macro is assigned to it says
The macro 'test.xls!AddMonth.AddMonth' cannot be found.

I have a module in Subtask.xlt that is named AddMonth and has a few
procedures in it, one being AddMonth.

From the this description can someone please provide more insight.


--
reddog9069
------------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...o&userid=24458
View this thread: http://www.excelforum.com/showthread...hreadid=388166