Solved

Word drop down list protection

Posted on 2012-03-27
4
404 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

751 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