Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help please - macro is on normal.dot, but not running in documents
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. |
#2
|
|||
|
|||
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/Custom...alTemplate.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 wrote in message ups.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. |
#4
|
|||
|
|||
Thanks very much, that was it ;-)
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Button Won't Stay on Toolbar | Microsoft Word Help | |||
Possible bug when recording a Word Macro | Microsoft Word Help | |||
Modifying a macro in a global template | New Users | |||
Save As is not working due to macro security settings | Microsoft Word Help | |||
2000 to 2002 macro and "Could not open macro storage" | Mailmerge |