CommandBarButton.PasteFace Method (Office)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Pastes the contents of the Clipboard onto a CommandBarButton.

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

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)