Drop down field no longer active after I unprotect document.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mlv-Oklahoma - 26 Jan 2007 22:18 GMT

I have a form document previously created by Macro where threre are drop down
options when you come a cross a active area. Once I unprotect the document to
modify, I can't seem to turn back the macro back on to get back where drop
down options become active. Instead, drop down field option dialog box comes
up. Any thought what I am doing wrong?

Thanks in advance

Reply to this Message

Doug Robbins - Word MVP - 27 Jan 2007 09:53 GMT

You need to reprotect the document for the formfields to work.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a form document previously created by Macro where threre are drop
>down
[quoted text clipped - 6 lines]
>
> Thanks in advance

Reply to this Message

Armey - 28 Jan 2007 19:20 GMT

Yes, Doug is correct. Here is a little more info in the form of an
example that will hopefully help you. Also, if you password protect
your template you will have to incorporate that into you vba code as
well.

Cheers!

Sub MySubforDD()

With ActiveDocument
.Unprotect
Select Case Selection.FormFields(1).Result
Case "My Item 1"
Selection.Tables(1).Cell(1, 3).Shading.BackgroundPatternColor
= wdColorRed
Case "My Item 2"
Selection.Tables(1).Cell(1, 3).Shading.BackgroundPatternColor
= wdColorOrange
Case Else
Selection.Tables(1).Cell(1, 3).Shading.BackgroundPatternColor
= wdColorWhite
End Select
.Protect wdAllowOnlyFormFields, NoReset
End With

End Sub

On Jan 27, 3:53 am, "Doug Robbins - Word MVP"
<d...@REMOVECAPSmvps.org> wrote:

> You need to reprotect the document for the formfields to work.
>
[quoted text clipped - 16 lines]
>
> > Thanks in advance- Hide quoted text -- Show quoted text -

Reply to this Message