Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-23-2015, 03:35 PM
brent chadwick brent chadwick is offline Help with drop down menu changing Italic font when unlinked Windows 8 Help with drop down menu changing Italic font when unlinked Office 2013
Advanced Beginner
Help with drop down menu changing Italic font when unlinked
 
Join Date: Mar 2015
Posts: 86
brent chadwick is on a distinguished road
Default Help with drop down menu changing Italic font when unlinked

Hey guys, I have a macro with a drop down and the exit macro is changing the Italic font when the fields are unlinked. I have a exit macro that protects the font but does not work on this particular macro. I'm stumped-
Here's the code for the macros-
Code:
Sub ObituaryCombinedMacro()
' Obituary Combined Macro
Application.ScreenUpdating = False
Dim Rng As Range, FmFld As FormField
Set Rng = Selection.Range
With ActiveDocument
.Bookmarks.Add Name:="Start"
  Rng.Collapse wdCollapseStart
  'Dropdown Menu for Record Collection
  Set FmFld = .FormFields.Add(Range:=Rng, Type:=wdFieldFormDropDown)
  With FmFld
    .Name = "ObituaryDD"
    .EntryMacro = ""
    .ExitMacro = "CondtionalContentObituaries"
    .Enabled = True
    With .DropDown.ListEntries
      .Add Name:="Obit Websites"
      .Add Name:="Ancestry"
      .Add Name:="Legacy"
      .Add Name:="ObitsforLife"
      .Add Name:="Obituaries.com"
      .Add Name:="Rootsweb"
      .Add Name:="Tributes"
      End With
      With Rng
     .End = FmFld.Range.End
     .Font.Italic = True
     .Collapse wdCollapseEnd
    End With
    End With
  .Protect Type:=wdAllowOnlyFormFields, NoReset:=True, Password:=Pwd
  End With
  Set FmFld = Nothing: Set Rng = Nothing
Application.ScreenUpdating = True
End Sub
Sub CondtionalContentObituaries()
Application.ScreenUpdating = False
Dim Prot As Variant, Rng As Range, FmFld As FormField
Const Pwd As String = ""
With ActiveDocument
  Prot = .ProtectionType
  If .ProtectionType <> wdNoProtection Then
    Prot = .ProtectionType
    .Unprotect Password:=Pwd
    With .FormFields("ObituaryDD")
      Set Rng = .Range.Paragraphs.First.Range
      Rng.MoveEnd wdCharacter, -1
      Rng.Start = .Range.End
    End With
    Select Case .FormFields("ObituaryDD").Result
       'Case for Tributes
      Case "Tributes"
      If InStr(Rng.Text, "") = 0 Then
      .Bookmarks.Add Name:="Middle"
      ActiveDocument.Bookmarks("Start").Range.InsertAfter "database, "
     ActiveDocument.Bookmarks("Start").Range.InsertBefore "United States Obituary Collection," & Chr(211)
        ActiveDocument.Bookmarks("Start").Range.InsertBefore Chr(210)
        ActiveDocument.Bookmarks("Middle").Range.Font.Italic = False
        With Rng
        .InsertAfter " (http://www.tributes.com : viewed " & _
          Format(Now, "D MMMM YYYY") & "), "
          .Font.Italic = False
          .Collapse wdCollapseEnd
          End With
           'Drop Down for Entry
    Set FmFld = .FormFields.Add(Range:=Rng, Type:=wdFieldFormDropDown)
    With FmFld
        .Name = "EntryDD"
        .EntryMacro = ""
        .ExitMacro = ""
        .Enabled = True
        With .DropDown.ListEntries
        .Add Name:="no entry for "
        .Add Name:="entry for "
        End With
    End With
     With Rng
     .End = FmFld.Range.End
     .Collapse wdCollapseEnd
         End With
           'Formfield for Firstname Lastname
        Set FmFld = .FormFields.Add(Range:=Rng, Type:=wdFieldFormTextInput)
        FmFld.TextInput.EditType wdRegularText, "Firstname Lastname", Format:="Title Case"
        With Rng
          .End = FmFld.Range.End
          .InsertAfter ", ("
          .Collapse wdCollapseEnd
          End With
          'Formfield for Death Year
        Set FmFld = .FormFields.Add(Range:=Rng, Type:=wdFieldFormTextInput)
        FmFld.TextInput.EditType wdRegularText, "Death Year"
        With Rng
         .End = FmFld.Range.End
          .InsertAfter ")."
          .Collapse wdCollapseEnd
            'Bookmark for End of Citation
           .Bookmarks.Add Name:="End"
           FmFld.ExitMacro = "UnlinkItalic"
           .Collapse wdCollapseEnd
           End With
           ActiveDocument.Bookmarks("ObituaryDD").Range.Font.Italic = True
           End If
      Case Else: Rng.Text = Chr(211)
    End Select
    .Protect Type:=Prot, Password:=Pwd, NoReset:=True
End If
End With
Set FmFld = Nothing: Set Rng = Nothing
Application.ScreenUpdating = True
End Sub
Sub UnlinkItalic()
'Unlink Database Macro
With ActiveDocument
 If .ProtectionType <> wdNoProtection Then
   .Unprotect Password:=Pwd
   End If
 Dim i As Long, FmFld As FormField, Rng As Range
 For Each FmFld In ActiveDocument.FormFields
 i = Len(FmFld.Result)
 Set Rng = FmFld.Range
 If FmFld.Range.Font.Italic = True Then
 Rng.Fields.Unlink
 Rng.End = Rng.End + i
 Rng.Font.Italic = True
 Else
   Rng.Fields.Unlink
   End If
   Next FmFld
lbl_Exit:
   Set FmFld = Nothing
   Set Rng = Nothing
    .GoTo What:=wdGoToBookmark, Name:="End"
          Dim Bookmark As Bookmark
      ActiveDocument.Bookmarks.ShowHidden = True
      If ActiveDocument.Bookmarks.Count >= 1 Then
         For Each Bookmark In ActiveDocument.Bookmarks
            Bookmark.Delete
         Next Bookmark
         Selection.MoveRight Unit:=wdCharacter, Count:=1
        End If
      End With
End Sub
I have only included one of the cases to shorten the code. Thanks for your help-
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
paragraph drop down menu noamsa Word 4 02-12-2015 01:36 PM
Need help with drop-down menu please cazclocker Excel 7 01-05-2015 04:07 PM
Help with drop down menu changing Italic font when unlinked 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
Merge fields & Drop down menu's ShadeTree Word 0 03-09-2010 08:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft