Document to read only

[Tom]

Some advice on the following would be appreciated:

Using Office 2003, we are using vba to automate, from Access, a table to
mail merge to a word master document which contains the merge fields within
its header. We have this working OK.

As a refinement we want to be able the user to edit text on that master
document and Save As to a new name.

What we would like to have is whereby the master document is read only, when
opened for text editing read only is temporarily disabled and on its close
it reverts to read only.

An additional refinement is if the text and merge fields contained within
the documents header could be 'locked' in some way to prevent a user
altering the text and merge fields.

If this is achievable how could it be done, if its not achievable are there
any alternatives to consider?

TIA for any input

Tom

 

[Jezebel]

The 'locking' part is doable: insert one or more section breaks, so the
editable part is in a section of its own. Then protect the other sections.

Forget about the read-only stuff. You won't achieve anything that you can't
do better through good office procedures. At best you'll add a lot of
complexity that provides only the illusion of security. If the user is
expected to SaveAs anyway, put a copy of the original document in a
read-only folder, and let the user do what they like with their version.

 

[Tom]

Jezebel

Thanks for input - how would I do:

'The 'locking' part is doable: insert one or more section breaks, so the
editable part is in a section of its own. Then protect the other sections.'



Tom