What Shape was Clicked ?
sCaller = Application.Caller
' then maybe
Select Case sCaller
' or maybe
Set shp = ActiveSheet.Shapes(sCaller)
Regards,
Peter T
"Gary''s Student" wrote in message
...
I have a set of about a dozen pictures on a worksheet, all linked to the
same
macro. When the Shape is clicked, the common macro executes. How can I
determine which Shape the user clicked?
--
Gary''s Student - gsnu2007xx
|