Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Spinner
 
Posts: n/a
Default Assigning VB to Grouped Objects

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 €ś<group name_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
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€¦?

Reply
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
Worksheet protection with grouped rows? pmw5 Excel Worksheet Functions 7 July 17th 07 04:49 PM
How do I make excel hide columns when it says cannot move objects Dale Excel Discussion (Misc queries) 0 November 10th 05 02:44 PM
How do I rotate a grouped object in Excel? Pen Gwynn Excel Discussion (Misc queries) 0 November 9th 05 04:52 PM
How to sort by grouped rows Mike Excel Discussion (Misc queries) 2 April 5th 05 10:51 PM
Numbering of Grouped Rows Phil Excel Discussion (Misc queries) 2 January 31st 05 11:38 PM


All times are GMT +1. The time now is 06:31 AM.

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

About Us

"It's about Microsoft Excel"