Edit

CommandBarButton.CopyFace method (Office)

  • Article

Copies the face of a command bar button control to the Clipboard.

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

expression A variable that represents a CommandBarButton object.

Remarks

Use the PasteFace method to paste the contents of the Clipboard onto a button face.

Example

This example finds the built-in Open button, copies the button face to the Clipboard, and then pastes the face onto the Spelling and Grammar button.

Set myControl = CommandBars.FindControl(Type:=msoControlButton, Id:=23) 
myControl.CopyFace 
Set myControl = CommandBars.FindControl(Type:=msoControlButton, ID:=2) 
myControl.PasteFace

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.