Hi,
Are there any way to trap the selection of a shape on
a workshhet through an event?

jacob

Jacob,

AFAIK, there is no event triggered by selecting a shape, but you could
easily add a macro to the shape to perform any action you desire.

HTH,
Bernie
MS Excel MVP

"jacob" wrote in message
...
Hi,
Are there any way to trap the selection of a shape on
a workshhet through an event?

jacob

And just to add to Bernie's suggestion. It can be the same macro for all the
shapes.

Option Explicit
Sub testme()
Dim myShape As Shape

Set myShape = ActiveSheet.Shapes(Application.Caller)

MsgBox Application.Caller & _
vbLf & myShape.Name & _
vbLf & myShape.TopLeftCell.Address
End Sub



Bernie Deitrick wrote:

Jacob,

AFAIK, there is no event triggered by selecting a shape, but you could
easily add a macro to the shape to perform any action you desire.

HTH,
Bernie
MS Excel MVP

"jacob" wrote in message
...
Hi,
Are there any way to trap the selection of a shape on
a workshhet through an event?

jacob

--

Dave Peterson