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

CommandBarButton.OLEUsage Property (Office)

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

Gets or sets the OLE client and OLE server roles in which a CommandBarButton control will be used when two Microsoft Office applications are merged. Read/write.

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. OLEUsage

expression A variable that represents a CommandBarButton object.

Return Value



This property is intended to allow you to specify how individual add-in applications' command bar controls will be represented in one Office application when it is merged with another Office application. If both the client and server implement command bars, the command bar controls are embedded in the client control by control. Custom controls marked as client-only (or neither client nor server) are dropped from the server, and controls marked as server-only (or neither server nor client) are dropped from the client. The remaining controls are merged.

If one of the merging applications isn't an Office application, normal OLE menu merging is used, which is controlled by the OLEMenuGroup property.


This example adds a new button to the command bar named "Tools", and sets its OLEUsage property.

Set myControl = CommandBars("Tools").Controls _ 
myControl.OLEUsage = msoControlOLEUsageNeither

See also


CommandBarButton Object

Other resources

CommandBarButton Object Members

© 2018 Microsoft