Solved

Word drop down list protection

Posted on 2012-03-27
4
402 Views
Last Modified: 2012-04-22
Hi,

I have a word 2010 document to which I'd like to add a drop down list form, the problem I'm having is that the control only activates itself if I protect my entire word document and select "editing restrictions to filling in forms only". If I do this though then the user cannot add/edit/delete any of the other text in the document, which makes no sense.

I need a drop down list without all the restriction protection stuff, is this possible?
0
Comment
Question by:FCapo
  • 2
  • 2
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37772594
You can put it in its own Section and protect that section only.
Put a Continuous Section Break (Page Layout tab, Page Setup group, Breaks button) before and after the dropdown. Then with more than one section in the document, 'Select sections...'  will appear under the 'Editing restrictions' dropdown in the task pane. This wil open a dialogue where you can tick the section to protect.

Note that certain limitations apply (e.g no spell checking) apply even to the unprotected sections of a forms-protected document.
0
 

Author Comment

by:FCapo
ID: 37772722
That's great, but I kind of need spell check to work, any other way around this, can I do it through code? I'm pretty good with vb?
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 37773031
You could have one macro to remove the protection and start the spell checking, and another to restore the protection
Sub RemoveProtection()
    ActiveDocument.Unprotect 'password
    ActiveDocument.CheckSpelling
End Sub
Sub RestoreProtection()
    ActiveDocument.Protect wdAllowOnlyFormFields, True ',password
End Sub

Open in new window

0
 

Author Comment

by:FCapo
ID: 37828074
I don't think the users that are working in the document will have the patience or understanding of having to run macros; is there no simple way of adding a list of choice that someone can click through without using protection and keeping spell checking?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Like many others, we try and discourage users from printing documents unnecessarily and instead send or share them electronically. However, this doesn't always work and documents are still printed. With this simple solution, if the user tries to …
It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question