|
Stopping macro prompts when you open or create a new
document
When
you create
macros in your templates, you will be prompted every time you open the
template or a new document based on the template, asking whether
to enable macros.
To stop the prompts, you will need to create a digital signature that lets
you tell Word to trust your own macros.
- Click on the Start button.
- Select Run.
- Click on the Browse button.
- Navigate to location of your Office
installation.
For eg: C:\Program Files\Microsoft Office\Office11
(Office10 if you've got Office XP; or to the location that you have
installed Office if in a different drive or folder)
-
Select SELFCERT.EXE.
-
Click Open.
The Run dialog box is displayed:
- Click OK.
The Create Digital Certificate dialog box is displayed:
- Enter your name.
- Click OK.
The following message is displayed.
- Click OK.
Inside Word
-
Open a document in which you use macros.
-
From the
Tools menu select Macros4Visual
Basic Editor.
-
In
the Project pane at the upper left, highlight the name of the
document.
-
From the Tools menu select Digital Signature.
-
Click on Choose.
-
Select the certificate you just created.
-
Click OK and click OK
again.
-
Close Visual Basic Editor.
-
Close the document, saving the changes.
-
Reopen the document.
-
If
a Security Warning dialog appears, select Always Trust Macros
From This Source.
-
Click on Enable Macros.
Repeat this procedure for any other document or template that has macros
embedded in it.
 Your
self-created certificate will be "trusted" only on your own
machine; the Always Trust Macros From This Source option will
be greyed out if you send a file that includes the certificate to any
other system. |