LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Assigning Macros to Grouped Shapes

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€¦?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning Macros Randy Excel Worksheet Functions 4 November 15th 07 08:56 PM
Assigning VB to Grouped Objects Spinner Excel Discussion (Misc queries) 0 December 29th 05 08:32 PM
Names of Grouped Shapes Mogwai Excel Programming 11 September 7th 05 05:32 PM
Changing Text in grouped shapes sebastienm Excel Programming 1 August 1st 04 02:54 PM
How can I loop to find the grouped shapes count David Cuthill Excel Programming 3 January 26th 04 08:22 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"