Enabling my own macros

  • Thread starter Thread starter BruceDLimber
  • Start date Start date
B

BruceDLimber

Greetings, friends!

A question for you: I'm having a terrible time trying to use Word macros
THAT I WROTE MYSELF because the system keeps disabling them for "security"
purposes. I even tried setting macro permissions to the equivalent of
"permit all" (which it duly warned me about), and they STILL won't work!

How can I force the system to allow me to run my own macros? Not having
them available is interfering tremendously with the editing I'm trying to
accomplish in Word.

Thanks! :-)

Bruce
 
Greetings, friends!

A question for you: I'm having a terrible time trying to use Word macros
THAT I WROTE MYSELF because the system keeps disabling them for "security"
purposes. I even tried setting macro permissions to the equivalent of
"permit all" (which it duly warned me about), and they STILL won't work!

How can I force the system to allow me to run my own macros? Not having
them available is interfering tremendously with the editing I'm trying to
accomplish in Word.

Thanks! :-)

Bruce
Click to expand...

Store your macros in templates, not in documents. And store those
templates in the folder shown as the User Templates folder in the
Folder Locations tab of the Options dialog.

Another, less convenient method is to digitally sign all your macro
projects. Use the SelfCert.exe program in the Office program folder
(on the Start menu, you should find it on the Office Tools submenu as
"Digital Certificate for VBA Projects) to create a certificate. Then,
in the VBA editor, open the macro project, go to Tools > Digital
Signature, and sign with the certificate. This will be valid only for
running the macros on your own computer, but it's better than nothing.
 
Are you actually saving the macros so that they are available next time you
run Word or open the document/template that contains them? Is this a company
PC on a network that clears the normal template each time you log in/out?
If this is Word 2007, are you storing the templates with the macros in a
trusted location?
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top