View Single Post
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Dawn Crosier, Word MVP Dawn Crosier, Word MVP is offline
external usenet poster
 
Posts: 425
Default How to protect drop-down list entries

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.




"Suzanne S. Barnhill" wrote in message
:

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 "Word@discus sions.microsoft.com wrote in message
...

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.


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