Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am operating Excel 2003 and use grouped shapes as in-sheet controls (i.e.
hand-crafted "buttons" are assigned to VB procedures). The general methodology works fine, except with Excel 2003 I cannot check what macro is assigned to the control. By default, all grouped shapes default to an event macro assignment of €ś<group name_click€ť. If you assign the group to a macro, the one you assign is connected to the group and runs when you click it. But, if you want to check the assignment (i.e. right click assign macro) it shows the default event macro and not the one you have assigned€¦! For reference: 1. I am not using the standard command buttons as these do not have the flexibility in formatting I require. 2. Ungrouped shapes do not exhibit this symptom. 3. In the previous version of Excel, once you assign a macro to a shape (grouped or single) Excel correctly shows the macro you assigned. Does anyone know if there is a way around this problem€¦? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning Macros | Excel Worksheet Functions | |||
Assigning VB to Grouped Objects | Excel Discussion (Misc queries) | |||
Names of Grouped Shapes | Excel Programming | |||
Changing Text in grouped shapes | Excel Programming | |||
How can I loop to find the grouped shapes count | Excel Programming |