locked
Custom Toolbar from Macro is not updating when Macro is updated RRS feed

  • Question

  • I have a Word template 2010 (.dotm) that has a macro that originated at least 2007, if not earlier.  There is a Customized Toolbar with Drop downs in the Add-ins tab populated from the Macro that contains a list of names. The drop down values have stopped updating as additional names have been added.  I can get the individual names to appear in the QAT but that is not what we need. How do I get the Drop Downs in Customized Toolbar to update so that the new names appear under the drop down as specified in the macro?  This is a snip it from the macro

    Drop down is US

    Name in Drop Down is Sales1

    Sub USSales1()

    '
    ' USSales1 Macro
    ' Macro recorded 2/5/2007 by Myerse00
    '
        Selection.TypeText Text:="Sales Region 1"
        Selection.MoveRight Unit:=wdCell
        Selection.TypeText Text:="149 Branch"
        Selection.TypeParagraph
        Selection.TypeText Text:="CA"
        Selection.MoveRight Unit:=wdCell
        Selection.MoveRight Unit:=wdCell
        Selection.TypeText Text:="805"
        Selection.TypeParagraph
        Selection.TypeText Text:="805"
        Selection.TypeParagraph
        Selection.TypeText Text:="Please email"
    End Sub

    Any suggestions would be very much appreciated.

    N-

    Monday, March 9, 2015 2:31 PM

Answers