View Single Post
 
Old 04-23-2013, 12:56 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Drizz

Follow these steps:
1. Open your Normal.dotm template (NOT a document).
2. Create a Macro in a Module as follows:

Sub AutoExec() 'runs when document is opened
'This name "AutoExec" is a Visual Basic reserved name for launching
'code when a Word is opened.
MsgBox "Ensure that you get Manager authorization", vbOKOnly + vbInformation, "NOTE"
End Sub

3. Save your template and close it.
4. Open Word in the normal manner and the AutoExec Macro will run BEFORE any document is opened.

Bear in mind that this will only work on your version of the Normal.dotm template if it is stored locally. If you are using a networked version of the Template then create the macro in that copy of the template. If you want it to work on multiple machines then you must do the same for each machine.
Good luck.
Come back to the forum if you need further help.
Good luck.
Tony

Last edited by OTPM; 04-23-2013 at 06:47 AM.
Reply With Quote