Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2005
    Posts
    50
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Grouped Active Objects Fail - Excel 2003 -> later Excel

    Many of my programs use active buttons (linked to the old macro language functions) that are grouped together with other objects, as in the attached picture. Almost all the active objects are chosen from the Forms toolbar. This works really well with Excel 2003. For example I can hide or unhide the named group object and the overall group helps users understand what to do. When I've attempted to migrate to Excel 2007 such grouped objects are pulled apart, rendering my systems useless. I'm assuming a very useful facility has been withdrawn.

    I'd very much appreciate advice on how to achieve the equivalent facility in later versions of Excel, i.e. grouping ordinary objects with active objects into a grouped and named object. I'd also appreciate an explanation of why such a facility has been withdrawn. It does not seem sensible to me.
    Attached Images Attached Images

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You can't do that any more: http://office.microsoft.com/en-us/ex...010236688.aspx
    I suspect it's down to the new SmartArt engine.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •