templates/email

[BB]

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
when someone sends it as an email the text carries over
but not the template, if i send it as an attachment then
the letterhead becomes alterable as if that code
disappears...is it possible to put that code elsewhere in
another module so that when emailed as an attachment
nothing can be altered? or if emailed to mail recipient
the whole thing carries over not just the text?
hope i made sense and thank you for any help...

 

[Shauna Kelly]

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