Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Long Documents / November 2003

Tip: Looking for answers? Try searching our database.

templates/email

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BB - 31 Oct 2003 16:34 GMT
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 - 01 Nov 2003 01:19 GMT
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...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.