Macros--Enable or Disable??

J

Joe McGuire

I have two or three Word documents containing macros (macroButtons, mainly)
that I access frequently, such as a telephone log to log long distance phone
calls. Whenever I open any of them I get a message asking if I want to
Enable or Disable macros. It is a minor pain in the guess what. Is there a
way to prevent this? I know I can shut offf all security and/or allow all
macros. But I am only talking about 2-3 documents. Is there a way to set
these few documents so I am not bugged by this message whenever I open them?
 
S

Suzanne S. Barnhill

If you save the macros themselves in Normal.dot or a document template
instead of in the documents themselves, you won't get a warning.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
C

Charles Kenyon

You need your macros in a template in a trusted location. Then you won't get
the warning. This is a general pain in macros in documents.
--
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




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

Joe McGuire

Actually, the document where this most often occurs is derived from a
template. The template is a monthly log of credit card phone calls and it
contains a macro button to enter the date and time of a call and another to
pull a Contact's name and phone number from Outlook. I use the document
thus created for a month and then create a new one from the template. The
template, along with others, is stored at the default location on our
Terminal Server. I do not seem to get the macro message when I create a
document from this or other templates that contain macros.

However, I wonder if some sort of link between my current document and the
template from which it was actually created was disrupted earlier this month
when the hard drive in our Terminal Server failed and was replaced. All
templates on the drive were lost and I had to copy all my templates from
another location.
 
J

Joe McGuire

(See my earlier post) I am not sure what you mean by "a trusted location."
I am storing them in the default folder. Is that "trusted"? Is there
something I have to do to make a folder "trusted"?
 
S

Suzanne S. Barnhill

On the Trusted Sources tab of Tools | Macro | Security, make sure that you
have "Trust all installed templates and add-ins" checked. This will cover
the user templates and workgroup templates folders as well as Word's Startup
folder. Unfortunately, the trust does not extend to the Office Startup
folder.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
C

Charles Kenyon

Yes, the link is disrupted. You need to reattach the template. Tools >
Templates and Add-Ins. Do this even if the template is showing as the
attached template. Also, make sure the box to update styles is not checked.
--
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




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

Joe McGuire

Charles--I went to Tools>Templates & Add-Ins but I frankly don't understand
what I am attaching to what. I am not really sure what "attaching" means in
this context. If I create a document from a template, is it "attached" to
that template after I save it? Does that mean every word document is
attached to some template, even if it was created from Normal.dot? Or is
this an issue only with templates or documents that contain macros? The
document in question was originally made using a template (phonelog.dot,
which contains macros--actually macro buttons), and I have a copy of that
template back in the default folder for templates. Am I attaching this
document to that template? Or to Normal.dot?
 
C

Charles Kenyon

Yes. Every Word document is attached to a template. By default, to the
template from which it was created. You can attach your document to either
its base template or to normal.dot or to a completely different template.
For more on the different kinds of templates, tabs on the file new dialog,
and locations of templates folders see
http://addbalance.com/usersguide/templates.htm.

See http://www.shaunakelly.com/word/templaterelations/index.html for more
about the connection between documents and templates.
--

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


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

Joe McGuire

Thanks to you both!

Joe McGuire said:
Charles--I went to Tools>Templates & Add-Ins but I frankly don't
understand what I am attaching to what. I am not really sure what
"attaching" means in this context. If I create a document from a
template, is it "attached" to that template after I save it? Does that
mean every word document is attached to some template, even if it was
created from Normal.dot? Or is this an issue only with templates or
documents that contain macros? The document in question was originally
made using a template (phonelog.dot, which contains macros--actually macro
buttons), and I have a copy of that template back in the default folder
for templates. Am I attaching this document to that template? Or to
Normal.dot?
 

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