Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Excel 2003/XP (soon to be Excel 2007/Vista :( Situation: Have a workbook with lots of shapes on various worksheets - all of which need to run essentially the same macro when they are clicked - it could be the exact same macro, if there was some way for the macro code to know which shape called it. The blindingly obvious creation of a separate macro for each shape is more than I can expect the end-users to know how (or remember) to do; a sad situation, but factual. Application.Caller doesn't work for shapes and I'm running out of good ideas to try. Since clicking on a shape doesn't select it, I can't use the .Selected property... Is this one of those "Well, who would want to do that?" things that MS either decided to ignore or never thought of - or has someone cracked this particular nut? Any help most gratefully accepted! James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Shape Macro | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Assigning Macro To Shape | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |