Skip to main content

CommandBars.AdaptiveMenus property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

This property checks or unchecks the check box control for the option to show menus in Microsoft Office as full or personalized. Read/write.



expression A variable that represents a CommandBars object.


Is True if adaptive menus are enabled for all applications in Microsoft Office. Read/write Boolean.

This control is set in any application by doing the following:

  1. On the Tools menu, select Customize.
  2. Select the Options tab.
  3. The Always show full menus option is located in the Personalized Menus and Toolbars section.


This example sets three options for all command bars in Office, including custom command bars and the controls on them.

With CommandBars
    .LargeButtons = True
    .DisplayFonts = True
    .AdaptiveMenus = True
End With

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>