Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Application.CommandBars Property

Office 2007
Sets or returns a CommandBars collection that represents the menu bar and all the toolbars in Microsoft Office Publisher.



expression   A variable that represents a Application object.

Return Value


This example enlarges all command bar buttons, enables ToolTips, and shows all menu items when displaying menus.

Visual Basic for Applications
Sub CmdBars()

    With CommandBars
        .LargeButtons = False
        .DisplayTooltips = True
        .AdaptiveMenus = False
    End With

End Sub

This example displays the Objects toolbar at the bottom of the application window.

Visual Basic for Applications
Sub ShowObjectsToolbar

    With CommandBars("Objects")
        .Visible = True
        .Position = msoBarBottom
    End With

End Sub

Community Additions

© 2015 Microsoft