Custom Toolbar from Macro is not updating when Macro is updated

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-

March 9th, 2015 10:32am

Easily customizable toolbars were a feature of Word 97-2003 that corporate IT departments complained about. MS eliminated them, giving us the QAT instead. Such a toolbar never would have been automatically updated.

You can modify your toolbar using Word 2003. Otherwise, you can learn to do it using vba. I've never had the patience.

You can create custom ribbon tabs which are both more powerful and useful using XML (not through the Word 2010 program directly). Customize the Ribbon (It doesn't take rocket science)

You may also want to explore the use of AutoText and Building Blocks. Automated Boilerplate Using Microsoft Word With the AutoTextList field these could perhaps replace your macros without learning a lot of programming. AutoTextList field - How to add pop-up lists to any Word document, so you can click your way through changes in seconds

Free Windows Admin Tool Kit Click here and download it now
March 9th, 2015 4:17pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics