Hi guys,
I am having some trouble getting an Auto macro to run from either the Startup.dot global template or the normal.dot global template.
I currently have the following code in the ThisDocument section of either template as a proof that the function is being run.
Sub AutoExec()
MsgBox ("Running Auto Macro")
End Sub
So far it appears that whenever I actually directly open these templates for editing the code is executed and the message box displayed. However when I open any other document the macro is not automatically run, it is available in the list of macros but is not actually being executed.
Has anybody got any ideas as to why the macro is not automatically executing and a way that I can get this to happen.
many thanks in advance
Andi
I am having some trouble getting an Auto macro to run from either the Startup.dot global template or the normal.dot global template.
I currently have the following code in the ThisDocument section of either template as a proof that the function is being run.
Sub AutoExec()
MsgBox ("Running Auto Macro")
End Sub
So far it appears that whenever I actually directly open these templates for editing the code is executed and the message box displayed. However when I open any other document the macro is not automatically run, it is available in the list of macros but is not actually being executed.
Has anybody got any ideas as to why the macro is not automatically executing and a way that I can get this to happen.
many thanks in advance
Andi