CommandBarButton.Copy method (Office)
Copies a command bar button control to an existing command bar.
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, see Overview of the Office Fluent ribbon.
Syntax
expression.Copy(Bar, Before)
expression A variable that represents a CommandBarButton object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Bar | Optional | Variant | A CommandBar object that represents the destination command bar. If this argument is omitted, the control is copied to the command bar where the control already exists. |
| Before | Optional | Variant | A number that indicates the position for the new control on the command bar. The new control will be inserted before the control at this position. If this argument is omitted, the control is copied to the end of the command bar. |
Return value
CommandBarControl
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.