Solved

Word drop down list protection

Posted on 2012-03-27
4
397 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

When creating Microsoft Word-based forms there may be a need to have a form field repeated throughout the whole document. For instance, with a company name, you may want this information repeated automatically throughout the document rather than man…
If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon. In Word 2007/2010, one of the things that I find missing when using styles is a quic…
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now