CommandBarButton.PasteFace method (Office)

Pastes the contents of the Clipboard onto a CommandBarButton.


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.



expression A variable that represents a CommandBarButton object.


This example finds the built-in FileOpen button and pastes the face from the Spelling and Grammar button onto it from the Clipboard.

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

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.