Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Word drop down list protection

Posted on 2012-03-27
4
Medium Priority
?
407 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 1500 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Suggested Courses

715 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