Macro not running on exiting legacy drop down menu.

gmayor · #1 12-11-2014, 08:17 AM

In order for the macro to be able to do anything in a protected form, you are going to have to include code to unprotect (and reprotect) the form. In your example:

Code:

Public Sub Test1()
Dim bProtected As Boolean
    'Unprotect the file
    If ActiveDocument.ProtectionType <> wdNoProtection Then
        bProtected = True
        ActiveDocument.Unprotect Password:=""
    End If
    With ActiveDocument.Content.Find
        .Text = "BOLD"
        .MatchWildcards = True
        .MatchCase = True
        .Replacement.Font.Bold = True
        .Execute Replace:=wdReplaceAll
    End With
    If bProtected = True Then
        ActiveDocument.Protect _
                Type:=wdAllowOnlyFormFields, _
                NoReset:=True, _
                Password:=""
    End If
End Sub

and note that your macro was called Test1 and not MyMacro ! Run Test1 on exit from the field. On Exit means when you leave the field, not when you select an item.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HELP -- Drop Menu for Reoccuring Data??	cscaudle	Word	1	03-02-2014 10:19 AM
Drop down menu with different value to display name	swsquish	Word	1	09-04-2012 08:45 PM
Adding Macro menu to the right click menu (Word 2007)	masam123	Word	0	10-14-2011 04:05 AM
Macro will not save to normal.dot file when exiting	bobbraun	Word	1	09-28-2010 06:26 AM
Merge fields & Drop down menu's	ShadeTree	Word	0	03-09-2010 08:19 AM