E
Ed
I created a template ( .dot) to hold some macros, UserForms, and library
references. The template resides in my UserName\Application
Data\Microsoft\Templates folder, alongside my Normal.dot. I then created a
new document based on this template, and created a Document_Open macro that
calls the UserForm (named "StartUp") in the template using StartUp.Show.
When opened, the code in the doc will not find the form ("Object required"
error). If I copy the form into the doc and code the buttons to fire macros
in the template, the macros can't be found.
What am I missing in my understanding to make this work?
Ed
references. The template resides in my UserName\Application
Data\Microsoft\Templates folder, alongside my Normal.dot. I then created a
new document based on this template, and created a Document_Open macro that
calls the UserForm (named "StartUp") in the template using StartUp.Show.
When opened, the code in the doc will not find the form ("Object required"
error). If I copy the form into the doc and code the buttons to fire macros
in the template, the macros can't be found.
What am I missing in my understanding to make this work?
Ed