Table of contents
Collapse the table of content
Expand the table of content

CommandBarControl.IsPriorityDropped Property (Office)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Gets True if the control is currently dropped from the menu or toolbar based on usage statistics and layout space. (Note that this is not the same as the control's visibility, as set by the Visible property). Read-only.

Note 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. IsPriorityDropped

expression A variable that represents a CommandBarControl object.

Return Value



A control with Visible set to True, will not be immediately visible on a personalized menu or toolbar if IsPriorityDropped is True.

To determine when to set IsPriorityDropped to True for a specific menu item, Microsoft Office maintains a total count of the number of times the menu item was used and a record of the number of different application sessions in which the user has used another menu item in the same menu as this menu item, without using the specific menu item. When this value reaches certain threshold values, the count is decremented. When the count reaches zero, IsPriorityDropped is set to True. Programmers cannot set the session value, the threshold value, or the IsPriorityDropped property. Programmers can, however, use the AdaptiveMenus property to disable adaptive menus for specific menus in an application.

To determine when to set IsPriorityDropped to True for a specific toolbar control, Office maintains a list of the order in which all the controls on that toolbar were last executed. A toolbar will always show as many controls as it has space to show, in the order of most recently used to least recently used. Controls with Priority set to 1 will always be shown and the toolbar will wrap rows, if necessary, to show these controls. Programmers can use the Priority property to ensure that specific toolbar controls are always shown, or to reposition toolbars so that they have enough space to display all of their controls.

You can use the following table to predict the number of sessions for which a menu item on a personalized menu will remain visible before the menu item's IsPriorityDropped property is set to True.

Number of uses of the command bar controlNumber of sessions of the application
0, 13
4, 512
6- 817
25 or more31


This example checks the IsPriorityDropped property for the first control on the command bar named "Custom." If IsPriorityDropped is True, the example sets the AdaptiveMenus property to False, restoring the dropped command bar.

If CommandBars("Custom").Controls(1).IsPriorityDropped Then 
    CommandBars.AdaptiveMenus = True  
End If

See also


CommandBarControl Object

Other resources

CommandBarControl Object Members

© 2018 Microsoft