I have a toolbar button that when clicked will import a template.

Code:
Sheets("Sheet1").Select
Sheets.Add Type: = "L:\SALES\TEMPLATE\MyTemplate.xlt"

This works fine. The problem is that the template has a VBA coded UserForm
that is supposed to run everytime a certain cell is selected. It works just
fine when I have the template open. But when I import the template using the
button, the UserForm does not come with the template.

How can I get the UserForm to stay with the template?

TIA
Alan