Help please - macro is on normal.dot, but not running in documents

G

google

Hello,

In my normal.dot, I have the following macro (found in an old post in
this group)...

Sub AutoOpen()
Application.Run "GoBack"
End Sub

which places the cursor at the last edit point when a document is
opened.

This worked fine in Office 97, but I have just installed Office 2003
and it no longer works. I can open normal.dot, look in the VB editor
and see the macro. When I open normal.dot, I am given the warning about
running macros.

If I open any other document though, I don't get the warning about
running macros, nor does the GoBack feature work.

Any idea why? Thanks.
 
S

Shauna Kelly

Hi Alan

The first step in troubleshooting this problem is to make sure you only have
one normal.dot. The location of normal.dot changes from version to version
of Word. So it's possible that the macro is in one file, but Word is
actually using another normal.dot.

To find the "real" normal.dot, follow the instructions in the section "To
find Normal.dot" at
How to change the default settings for Word documents

http://www.word.mvps.org/FAQs/Customization/CustomizeNormalTemplate.htm


That will help you locate the real normal.dot that Word is using.

For what it's worth you should not expect to get a macro warning when you
open a document, and the macro kicks in, assuming appropriate settings.
Check Tools > Options > Security > Macro Security. On the Security Level
tab, the generally recommended level is Medium. On the Trusted Publishers
tab, if "Trust all installed add-ins and templates" is ticked, then you
won't get a macro warning using a macro in normal.dot.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
 
G

Graham Mayor

Set macro security to medium and to trust installed templates and add-ins.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top