How to protect drop-down list entries

  • Thread starter JW having trouble with Word
  • Start date
J

JW having trouble with Word

I created a form using a standard document template. The template has
drop-down lists in it. What I am trying to do is protect these fields once
they have been selected. For example, I want to be able to fill the form out,
select the drop-down items that I need, and then save the form as a .doc.
What I dont want to happen, is someone going in weeks or months later and
being able to change these drop-down values.
I tried setting the document to read-only, but when I emailed it to
someone, they were still able to change the drop-downs. Any tips or
suggestions are greatly appreciated.
 
S

Suzanne S. Barnhill

You could unlink the form fields with Ctrl+Shift+F9.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"JW having trouble with Word" <JW having trouble with
(e-mail address removed)> wrote in message
news:[email protected]...
 
D

Dawn Crosier, Word MVP

I have a form which has an automation of Suzanne's suggestion. I have a
command button on the form for "Final". Attached to the command button
is the following macro.

Sub FinalForm()
'Prepare the document to be saved in a final form.
If ActiveDocument.ProtectionType = wdAllowOnlyFormFields Then
ActiveDocument.Unprotect Password:=""
End IF
'Unlink the fields
Selection.WholeStory
Selection.Fields.Unlink
End Sub


If you desire, you could then reprotect the document after you have
unlinked the fields.


--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.




You could unlink the form fields with Ctrl+Shift+F9.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"JW having trouble with Word" <JW having trouble with
HYPERLINK "mailto:[email protected]"(e-mail address removed)> wrote in message


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.18/1255 - Release Date: 2/1/2008 9:59 AM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.18/1255 - Release Date:
2/1/2008 9:59 AM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top