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



google@alansilver.co.uk
07-10-2005, 12:04 AM
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.

Shauna Kelly
07-10-2005, 12:04 AM
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


<google@alansilver.co.uk> wrote in message
news:1120044760.944032.46030@g47g2000cwa.googlegroups.com...
> 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.
>

Graham Mayor
07-10-2005, 12:04 AM
Set macro security to medium and to trust installed templates and add-ins.

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

google@alansilver.co.uk wrote:
> 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.

google@alansilver.co.uk
07-10-2005, 12:04 AM
Thanks very much, that was it ;-)


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