JACKPOT!
When I looked at the "Macros In" item, I discovered that the macros were
being placed into the normal.dot and not the document. I simply copied them
from the normal.dot to the .doc and then deleted them from the
normal.dot.....SUCCESS!
Thank you for your help Suzanne.
"Suzanne S. Barnhill" wrote:
In Tools | Macro | Macros, you can change the "Macros in" setting to pin
down the location of a specific macro.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"PeterM" wrote in message
...
I'm relatively new to macros in Word...I'm experienced in Access. I
understand what you are saying about the .dot and .doc but I'm now really
not
sure where they are. When I open the .doc and go to
ToolsMacroMacros
then the two macros appear in the Macro window. I then can edit them etc.
Does that mean they are in the .doc or .dot? I really don't remember
doing
anything with the .dot.
thanks for your help Graham!
"Graham Mayor" wrote:
If the macros are in the document and the macro security is set to
medium
you will *always* get a warning prompt. If you are absolutely certain
that
the macros are stored *in the document* and you are getting no warning
and
no access, then it is possible that the Word data key in the registry is
corrupt. Back up that key and then delete it. Allow Word to build a new
one
as shown at http://www.gmayor.com/my_toolbars_are_missing.htm
My guess is that the macros were not in the document but in the
normal.dot
template and this was replaced when the machines were rebuilt. Yours
still
works because the macro is still in your normal.dot. Storing macros in
templates is a much better idea than storing them in documents.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
PeterM wrote:
yes, they have been working for over 2 months now, it's just since
they rebuilt their machine that this has become a problem
"Graham Mayor" wrote:
Are you sure that the macros are supposed to be in the document and
not in the template (or your normal.dot)?
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
PeterM wrote:
I have a word doc (2003) which contains two macros. The
Document_Open() event calls one of the macros. Everything has been
fine until recently. Several of my users have had to rebuild their
machines including upgrading to XP and installing Office 2003. Now
when they open the word doc they get a VBA compile error saying the
macro name is not defined. When I look at the doc the macros are
there...I have the users to go ToolsMacroMacro and they do not
see the two macros contained in the doc. They have emailed the doc
to me and I can see the macros, but they cannot. Is there some
default in word somewhere where you need to enable macros? Their
macro security is set to Medium, we tried setting it to low, but
that didn't make any difference.
Any help would be greatly appreciated!