[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

Word drop down list protection

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
FCapo
Asked:
FCapo
  • 2
  • 2
1 Solution
 
GrahamSkanRetiredCommented:
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
 
FCapoAuthor Commented:
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
 
GrahamSkanRetiredCommented:
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
 
FCapoAuthor Commented:
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

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now