Auto Run On Open

[PrinceNeptune]

Hi All,

My question is actually regarding Microsoft Word but I assume it could be used in the same fashion as Excel, so I hope it is appropriate to ask the question here.

We have a Macro in Word in a template that we want to run the moment the document is open (after the prompt of whether to allow macros or not). The macro is all setup, we just need the autorun.

I think we just need to create it in some type of Sub Open_Document() or something very similar.

Your help is greatly appreciated.

 

[dave3009]

Perhaps

Private Sub Document_Open()
Call MyMacro
End Sub

In your ThisDocument module

 

[PrinceNeptune]

Perfect, thank you.

 

[dave3009]

You're welcome