macro associated with shape object, useful approach if can be solv

[Guest]

I have a several shape objects in a spreadsheets and want to assign macro to
the shape click event. My question is, instead of assigning each shape to a
specific macro, if I can assign all shapes to the same macro. Then, inside
the macro, based on which shape calls (by name or somthing else), do
different things. But I have a hard time to find which shape calls, by using
something like ActiveShape (my imagination). The shape seems not in selected
mode when clicked. The shapes are dynamically generated and I am using Excel
XP.
Thanks for your help.

 

[Tim Williams]

sub ShapeClick()
msgbox application.caller
end sub