Shape.OnAction Property (Excel)

Returns or sets the name of a macro that’s run when the specified object is clicked. Read/write String.

expression .OnAction

expression A variable that represents a Shape object.

Setting this property for a menu item overrides any custom help information set up for the menu item with the information set up for the assigned macro.

This example causes Microsoft Excel to run the ShapeClick procedure whenever shape one is clicked.

Worksheets(1).Shapes(1).OnAction = "ShapeClick"

Concepts

Other resources

Show:
© 2015 Microsoft