Macro Security Warning

[Guest]

Recently I activated Word 2002 on my XP. All was working fine until recently.
Now when opening Word a Security Warning window opens saying "C:\Program
Files\Microsoft Office\OFFICE 11\STARTUP\MyobMn97.dot" contains macros, and a
selection is provided to disable macros, enable macros, or Help. I'm sure it
has something to do with the fact that I am severly computerly challenged,
but when I selected Help, I didn't find anything I recognized as help for
this situation. However, from a search in this forum for "macros" I found:

Subject: Re: how do I get rid of the security warning when opening Word?
6/19/2006 10:47 AM PST
See the article "Why is my "Blank Document" not blank?" at:
http://www.word.mvps.org/FAQs/AppErrors/BlankDocNotBlank.htm
by Doug Robbins - Word MVP

I didn't understand what the author was trying to explain or what the fix
was sposed to fix but but because it offered a way to get rid of the security
warning when opening Word I tried following those instructions anyway.
Apparently I didn't do well because nothing changed. In addition, I just did
a search for Normal.dot and didn't find anything. It's really not such a big
deal. Word still works fine and
having to select 'enable macros' at every Word opening will not kill me or
anything. It would simply be less cumbersome if there was a fix - that
computerly challenged Me can follow. Any ideas or suggestions anyone would
have to offer would be greatly appreciated. Thanks, K.

 

[Jay Freedman]

Rest assured, computer challenged or not, you wouldn't have found a
solution for this in the Help. Doug Robbins's article isn't really
what you need, either.

The core of the problem is this: There are only a couple of folders
that Word "trusts", meaning that macros in templates in those
locations are allowed to run without being challenged. One of those is
the Templates folder, and another is Word's Startup folder. Both of
these are subfolders within C:\Documents and Settings\<your
name>\Application Data.

Application Data is a hidden folder. Unless you change a setting in
Windows Explorer, you can't see the hidden folder or files within it,
and a file search won't find them. To be able to see the hidden stuff,
start Windows Explorer, click Tools and then Folder Options, and
choose the View tab. In the list of options, click "Show hidden files
and folders" and click OK.

The Templates folder holds the Normal.dot template and some other
templates that are used to create new documents.

The Startup folder is often empty. But any template that's stored
there gets loaded whenever Word starts, and macros and toolbars in the
template are available in all documents. (These templates are often
called "global" because they apply to all of Word.)

There's another Startup folder, the one named in the error message you
quoted: C:\Program Files\Microsoft Office\OFFICE 11\STARTUP. Templates
stored there will also be loaded when Word starts. But this is _not_ a
"trusted" location, so Word challenges the macros in the template.
Apparently MYOB (and a number of other programs that want to add
macros and toolbars to Word) either don't understand that distinction,
or think it's too much trouble to locate the real Startup folder
within your profile (the path with your name in it). So they stick
their templates in the Startup under Program Files and leave you to
deal with the consequences.

The fix for your problem is easy: Move (don't copy) the file
MyobMn97.dot from the Startup under Program Files to the Startup under
Documents and Settings.

To finish up, open Word and go to the Tools > Macro > Security dialog.
Click the Trusted Publishers tab, and check the box for "Trust all
installed add-ins and templates". (In this option, "installed" means
specifically "stored in one of the trusted locations".)

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Guest]

Wow that worked great. And because your instructions were very clear the task
was easy. Really appreciate your help. K.