Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro associated with shape object, useful approach if can be solv
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro associated with shape object, useful approach if can be solv
sub ShapeClick()
msgbox application.caller end sub -- Tim Williams Palo Alto, CA "pshen" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmatically adding buttons to a worksheet (Shape Object) | Excel Programming | |||
How to tell wich object/shape was clicked | Excel Programming | |||
XL2000: Shape object events | Excel Programming | |||
Hyperlink within the TextFrame of Shape Object..? | Excel Programming | |||
How to hide Excel window when activating a Shape object | Excel Programming |