Why does password to modify follow in a "saved" read-only doc?

[Guest]

We have documents "templates" that we use over and over again. Many times
people have opened them up, modified them to suit their needs and saved over
the "templates". We have tried to password protect them (to modify them) so
that the altered documents have to be "saved as" and not saved over the
templates.

In Excel, the password protection does not follow the "saved-as" file. In
Word, you have to have the password to open up the modified "saved-as" file.
How can we get around this?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Q29ubmll?=,

We have documents "templates" that we use over and over again. Many times
people have opened them up, modified them to suit their needs and saved over
the "templates". We have tried to password protect them (to modify them) so
that the altered documents have to be "saved as" and not saved over the
templates.

In Excel, the password protection does not follow the "saved-as" file. In
Word, you have to have the password to open up the modified "saved-as" file.
How can we get around this?

the difference between Excel and Word templates is that Word maintains a link to
the template at all times (Tools/Templates and Addins, the "Attached template").
In this way, it has access to macros, toolbars, keyboard shortcuts etc. in the
template.

What you could do is put a macro in the templates that changes the "Attached
Template" to a different template. If the documents don't need to access
anything in the original templates at a later point (after they've been closed)
you could have an AutoClose macro in the templates that links them to the
Normal.dot template, for example. (Normal.dot is the default template for "blank
documents")

Sub AutoClose()
ActiveDocument.AttachedTemplate = NormalTemplate
End Sub

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail