Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have several Rectangle shapes on a worksheet. I would like to assign a generic macro (sub) to each of them, but using the Name of the shape in the macro. i.e. objShape1, ObjShape2 two shape objects assign macro : Generic_Macro to both Sub Generic_Macro() MsgBox <triggeringshape.Name End Sub can this be done? Or could I "morph" a rectangular shape object in a class module and write some special event for the OnAction event of the shape? Question 2: is there any way to have a MouseOver event triggered for a Shape? Thanks in advance! Gyula PS: please email to |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
monthly cycle events to add to calendar object | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Hyperlink within the TextFrame of Shape Object..? | Excel Programming | |||
How to hide Excel window when activating a Shape object | Excel Programming | |||
How to hide Excel window when activating a Shape object | Excel Programming |