CommandBars.AdaptiveMenus Property (Office)
This property checks or unchecks the check box control for the option to show menus in Microsoft Office as full or personalized. Read/write.
The use of CommandBars in some Microsoft Office applications has been superseded by the new ribbon component of the Microsoft Office Fluent user interface. For more information, search Help for the keyword "ribbon."
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:
On the Tools menu, select Customize.
Select the Options tab.
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 Microsoft Office, including custom command bars and the controls on them.
With CommandBars .LargeButtons = True .DisplayFonts = True .AdaptiveMenus = True End With