#1   Report Post  
PeterM
 
Posts: n/a
Default Unavailable Macros

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!
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

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!



  #3   Report Post  
PeterM
 
Posts: n/a
Default

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!




  #4   Report Post  
Charles Kenyon
 
Posts: n/a
Default

Any chance they have their security on the new machines set to the default
"High" which would disable the macros without notice. Not sure what that
would do to trying to view macros.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
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!






  #5   Report Post  
PeterM
 
Posts: n/a
Default

I had them set their macro secruity level to low and it made no difference.
Not being able to view the macros is really not the problem, it's the
inability to call the macro that is causing the document to fail..........

"Charles Kenyon" wrote:

Any chance they have their security on the new machines set to the default
"High" which would disable the macros without notice. Not sure what that
would do to trying to view macros.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
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!








  #6   Report Post  
Charles Kenyon
 
Posts: n/a
Default

Not low. Never low. Medium.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
I had them set their macro secruity level to low and it made no difference.
Not being able to view the macros is really not the problem, it's the
inability to call the macro that is causing the document to fail..........

"Charles Kenyon" wrote:

Any chance they have their security on the new machines set to the
default
"High" which would disable the macros without notice. Not sure what that
would do to trying to view macros.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
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!








  #7   Report Post  
PeterM
 
Posts: n/a
Default

they reset their level back to high because it made no difference which
security level was chosen...the macros were never being executed.......does
anyone else have an idea why?

"Charles Kenyon" wrote:

Not low. Never low. Medium.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
I had them set their macro secruity level to low and it made no difference.
Not being able to view the macros is really not the problem, it's the
inability to call the macro that is causing the document to fail..........

"Charles Kenyon" wrote:

Any chance they have their security on the new machines set to the
default
"High" which would disable the macros without notice. Not sure what that
would do to trying to view macros.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
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!









  #8   Report Post  
Charles Kenyon
 
Posts: n/a
Default

The macros will _not_ be executed and you won't find out why if the security
is set to high.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
they reset their level back to high because it made no difference which
security level was chosen...the macros were never being
executed.......does
anyone else have an idea why?

"Charles Kenyon" wrote:

Not low. Never low. Medium.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
I had them set their macro secruity level to low and it made no
difference.
Not being able to view the macros is really not the problem, it's the
inability to call the macro that is causing the document to
fail..........

"Charles Kenyon" wrote:

Any chance they have their security on the new machines set to the
default
"High" which would disable the macros without notice. Not sure what
that
would do to trying to view macros.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"PeterM" wrote in message
...
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!











  #9   Report Post  
Graham Mayor
 
Posts: n/a
Default

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!



  #10   Report Post  
PeterM
 
Posts: n/a
Default

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!






  #11   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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!





  #12   Report Post  
Charles Kenyon
 
Posts: n/a
Default

Macros are stored, by default, in normal.dot. This is not usually where you
want them, but it is a good default. Other places are in the attached
template (usually the template used to create the document) or in the
document itself. We can't tell you where you put your macros anymore than we
can tell you where you put your keys. Suzanne points out one way to find the
macros within the Word interface.

The other is to go into the vbe by pressing Alt-F11. Then search for the
macros using Find.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"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!






  #13   Report Post  
PeterM
 
Posts: n/a
Default

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!





  #14   Report Post  
PeterM
 
Posts: n/a
Default

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 Charles.

"Charles Kenyon" wrote:

Macros are stored, by default, in normal.dot. This is not usually where you
want them, but it is a good default. Other places are in the attached
template (usually the template used to create the document) or in the
document itself. We can't tell you where you put your macros anymore than we
can tell you where you put your keys. Suzanne points out one way to find the
macros within the Word interface.

The other is to go into the vbe by pressing Alt-F11. Then search for the
macros using Find.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"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!






  #15   Report Post  
PeterM
 
Posts: n/a
Default

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 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!




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do my macros disappear? Lisa Microsoft Word Help 3 November 13th 13 01:08 PM
Sharing toolbars and macros?? Biljackson Microsoft Word Help 1 April 4th 05 05:23 AM
Alternative to macros for creating menu-driven functions? Widmer Microsoft Word Help 5 February 7th 05 06:27 AM
How do we make our macros "signed"? StargateFan New Users 6 February 6th 05 03:47 PM
Macros in 2003 multiple but connected problems? V-ger Microsoft Word Help 8 January 18th 05 09:42 PM


All times are GMT +1. The time now is 01:04 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"