Embedding Macros to pass around

A

Angyl

I'm setting up macros to make life a little easer in a Word form on my
computer. However, when I e-mail the document to others, the macros don't go
with it. So I'm going from cpu to cpu in the office setting up the macros
manually.

Is there a way to "embed" the macros I'm creating in the document itself so
that if I create them and e-mail the document the macros go along with it?
 
A

alborg

Have you tried to use a new template then use Word's VBA capability to
"embed" the macros? A regular document will use your computer's Normal.dot
template, and then will use the Normal.dot templates in other computers, all
of which will lack your macros.

All you have to do is:

1) Set up a new template, put in your document text.
2) Go to the toolbar on top then click on Views-> Toolbars-> Visual Basic
3) Then click on the "Visual Basic Editor"
4) Now right click on the temple title and begin adding UserForms and Modules.
5) If you find the Normal.dot modules, you can find the macros that you wish
to transfer over to your new template document- just simply cut/paste the
text!

You can read a biginner's FAQ on macros here:
http://word.mvps.org/faqs/MacrosVBA/ModifyRecordedMacro.htm

Cheers,
AL

Cheers,
Al
 

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