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
Bookmarks