Hi webharvest,
The best approach might be to configure the document as a Word form with a combination of protected and unprotected Sections, delineated by continuous or next-page Section breaks.

In the protected Section(s), you would have formfields into which the users could input data (eg the Proposal Name) only. Anything else in a protected Section would be inaccessible. If the same data that is to be input into a formfield appears in multiple places, you could set the formfield properties to 'calculate on exit' and have cross-references at the other locations, all pointing to the formfields' internal bookmark names.



In the unprotected Section(s), you'd have any content that the users are allowed to edit.

See attached document.

Attached Files

Form Demo.doc (32.0 KB, 36 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

That sounds like a good approach. But I do have a couple of questions

1) Is there a good way to call up the userform after the initial creation of the document? Right now in your example doc if the person clicks on the protected area they would have no way of knowing they can only change that field by opening the userform.
What would be ideal is when the person clicks on the protected text the userform automatically opens. Another alternative is when the user clicks on the protected text a note pops up telling the user how to open the userform.

2) The problem is I don't want to put a macro button on the page because won't that show up when the document is printed?

3) If the section is protected and info can only be put in via the form do I need to turn protection off and then turn it back in VBA when the form goes to enter the update? What is the code for that?

Thanks