Lene Fredborg, DocTools, har hvert år siden 2008 modtaget den prestigefyldte pris som Microsoft Most Valuable Professional (MVP) i Word – link til information om MVP Award'en DocTools - dokumentautomatisering - add-ins, makroer og skabeloner til Microsoft Word (logo) Dokumentautomatisering
Add-ins & Makroer
Skabeloner
Til Microsoft Word
Dokumentautomatisering, skabeloner (templates), add-ins og makroer til Microsoft Word (grafik)



Bogmærk denne side | Tip en ven om DocTools


Søg thedoctools.com:

Custom Search



Macros...

Troubleshooting – Toolbar Missing on Add-Ins Tab

If you are using Microsoft Word 2007 or 2010 and if you have created custom toolbars in earlier versions of Microsoft Word, those toolbars can be made available from the Add-Ins tab in Microsoft Word 2007 or 2010. In order to appear on the Add-Ins tab, the toolbars must be part of templates stored in Microsoft Word's Startup folder. However, I have experienced a few times, that a custom toolbar did not automatically appear in Microsoft Word 2007 or 2010. This article provides help on how you can make a missing custom toolbar visible.

Terms of use

You are welcome to use the macros and Word tips provided on this website. The contents is copyright. You may not reproduce any of contents (with or without modification or credits) elsewhere on the web, or on CD. Please link to the contents on this website instead.

Please note that all free Word tips, macros, add-ins and demos are provided "as is" and without obligation. See also detailed Terms of use.


Solution 1 – scroll the toolbar into view

The Add-Ins tab in Microsoft Word 2007 or 2010 is automatically added if you have templates in the Microsoft Word Startup folder containing custom toolbars.

The ribbon on the Add-Ins tab can show up to three toolbars below each other. If the installed add-ins include more than three custom toolbars, Microsoft Word will add extra group(s) of toolbars to the right of the first three. Depending on the length of the toolbars, the window size and the screen resolution, the extra toolbars may be invisible because they reside outside the window.

If you see a small arrow at the right end of the Add-Ins ribbon as illustrated below, click the arrow and the invisible part of the toolbar(s) will scroll into the window. A corresponding arrow will now appear to the left in the ribbon, letting you scroll in the opposite direction.

Click the arrow in the Add-Ins ribbon to scroll

Solution 2 – what to do if the toolbar is still missing

If you cannot scroll the toolbar into view, you should be able bring it back using a line of macro code. This requires that you know the exact name of the toolbar:

1. Press Alt+F11 to open the Visual Basic Editor (VBE).

2. If the Immediate window is not visible at the bottom of the VBE window, press Ctrl+G to display the window.

3. In the Immediate window, type the following line of code and press Return.


CommandBars("MyToolbarName").Visible = True


You must replace "MyToolbarName" with the correct name of the missing toolbar. The name is not case sensitive. See the illustration below.

The Immediate window in the VBE

If the message shown below appears, the toolbar name you have typed is not correct.

Error if toolbar name is wrong

If the toolbar name was correct, the toolbar should now be visible on the Add-Ins tab.

What to do if you do not remember the toolbar name?

If you do not know or remember the toolbar name, you can use the macro below to help you find the name. The macro will display the names of all currently installed custom toolbars:


Sub ShowNamesOfCustomToolbars()

    Dim oBar As CommandBar
    Dim strMsg As String

    strMsg = "Currently installed custom toolbars:" & vbCr & vbCr

    For Each oBar In CommandBars
        If oBar.BuiltIn = False Then
            'Add name to message
            strMsg = strMsg & oBar.Name & vbCr
        End If
    Next oBar

    'Show message
    MsgBox strMsg, vbOKOnly, "Custom Toolbars"

End Sub



Related information

See general information about VBA macros and code snippets, incl. information about how to install macros.



Top of page

Back to Macros...




Copyright © 2006-2017 Lene Fredborg – DocTools ApS – alle rettigheder forbeholdt | Microsoft Word skabeloner (templates) – add-ins – VBA makroer | Spar tid og arbejd mere effektivt i Microsoft Word
Privat politik | Betingelser for brug | Om cookies | Bogmærk denne side | Tip en ven | Links | Kontakt