close

I am operating Excel 2003 and use grouped objects as in-sheet controls (i.e.
the objects 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 objects
default to an event macro assignment of ??lt;group namegt;_click?? If you assign
the group a macro, the one you assign is connected to the object and runs
when you click it. But, if you want to check the assignment (i.e. right click
gt; 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 objects do not exhibit this symptom.
3. In the previous version of Excel, once you assign a macro to an object
(grouped or single) Excel correctly shows the macro you assigned.

Does anyone know if there is a way around this problem??

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()