Document_Open does not work in Word 2007 template

[ukzrsuwy5p]

For employees to work, I need to put some functionality into the Document_Open macro. I want to put this macro in a template (.dot) and place it on the network. Office 2007 is installed on most machines, and I'm testing on it. I create a document, insert the macro code, save it as a template (.dot). I use the following macro as a test:

Sub Document_Open()
MsgBox "ABC" 
End Sub

Next, I create a document (.doc) and change the document template on my created template. I allow the execution of macros, the macro work. I save and close the document, when I reopen the document and enable macros, our macro does not work. What the problem is I can’t understand. Thank!

[Guessed]

May be lost in translation.

Template should be saved as (.dotm). Document should be saved as (.docx). Which module is the Document_Open saved in?

[ukzrsuwy5p]

Originally Posted by Guessed

May be lost in translation.

Template should be saved as (.dotm). Document should be saved as (.docx). Which module is the Document_Open saved in?

Thank! In the TnisDocument module. Did you manage to repeat my situation? Did the macro work? If the template is .dot and the document .doc will not work?

[gmayor]

The code should work as long as the document created from the template can still see the template that contains the code. If the document is e.g. sent to a third party, then the document will no longer see the template and the code will not be available.

If you want the code to run when the document is created the macro should be Document_New

[ukzrsuwy5p]

Originally Posted by gmayor

The code should work as long as the document created from the template can still see the template that contains the code. If the document is e.g. sent to a third party, then the document will no longer see the template and the code will not be available.

If you want the code to run when the document is created the macro should be Document_New

The document can see the template, but the macro code does not work. If we open the template and enable macros, then the macro code works. Next, save the template as a document, open the document, enable macros, the macro code does not work.

[gmayor]

Make the template trusted or put it in a trusted location and try again.