I have built a Word 2013 form which contains Legacy Controls, ActiveX Controls and the Date Picker from the default controls in the Developer tab.


I am relatively new building forms in Word. I hope this is not too wordy, but I am not sure how to explain it.

This form is for Supervisors and managers to enter information about new Employees. Some of the information, Name, Supervisor name, start date, approving department head and email for department head.

I have added several VBA Macros, one to read the name of the Department Head and get their email from Active Directory. This all works good, even when I open a new document from the template.

I added a button at the bottom of the form to validate all required information, which as a dotm works great. But after saving the dotm file, and open the dotm as a new document the code that I entered in the button's click event is not there. It seems that the code is not being written to the Click event of the new form. If I unprotect the new document and click on the Developer Tab and view the code, All I have is Private Sub Submit_Click() and no code. Listed underneath the new Document in the VBA editor is the original template. Clicking on ThisDocument and viewing the code, I see my Private Sub Submit_Click() with all the code I wrote.

I have gone into the Trust Center and enabled Macros and ActiveX.
I have searched for answers, but found none that work. Am I doing something wrong? Any help would be appreciated. Thank you in advance for all your help.

Sounds like your control in the new document is in design mode. What happens if you come out of design mode?

Why are you mixing all of these control types? I would use content controls and a ribbon or QAT command button. ActiveX controls carry a lot of baggage.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

I suspect that you shouldn't be using the ThisDocument module for your code. In the case of the code sitting in an attached template, ThisDocument refers to the attached template rather than the activedocument.

The Submit_Click code should be sitting in the userform's own module.

If that doesn't solve it, can you post your template?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Guessed. It suspect that he is using a ActiveX control (not a Userform) and the command button code has to be in the ThisDocument module.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Re-reading the OP, I suspect that your suspicion is correct Greg. :-)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thank you all for your suggestions. I built a UserForm and added the controls from there. Seems to be working, except I am trying to get a Date Picker into the UserForm. I will update this thread as I continue working on it.

Thank you