Hi BB
VBA code can reside in a template or in a document. So you could copy
the VBA code to the document. However, when your user opens the
document, the user will get a security message warning that the file
contains macros. This isn't really satisfactory.
Or, you could email the template along with the document. But the user
would have to save the template in his/her templates folder and the
document in a separate folder. This isn't really satisfactory either.
Alternatives are:
1. If you want your user to edit the document, use Forms protection to
protect certain parts of the document. But be aware of the limitations
of this described at
http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm.
2. If you don't want the user to edit the document, save the document as
a PDF file and email that.
Hope this helps.
Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
Melbourne, Australia
> i have made a letterhead template and it is not alterable
> because i put the vb code in the module to make it so but
[quoted text clipped - 6 lines]
> the whole thing carries over not just the text?
> hope i made sense and thank you for any help...