+ Reply to Thread
Results 1 to 3 of 3

Grouping and Ungrouping Checkboxes

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    7

    Grouping and Ungrouping Checkboxes

    Hello

    Can someone help me here.

    I am able to group certain checkboxes using the following code. I got it through the record macro function in excel 2007

    Sub Macro1()

    ActiveSheet.Shapes.Range(Array("Check Box 2", "Check Box 3", "Check Box 4", "Check Box 5")).Select

    Selection.ShapeRange.Group.Select

    End Sub


    In the same manner the code (got it through the record macro function) for ungrouping is

    [Sub Macro2()
    ActiveSheet.Shapes("Group 14").Select
    Selection.ShapeRange.Ungroup.Select
    End Sub]

    But each time the grouping happens the group of checkboxes get a new number and the ungrouping macro cannot be used.


    I would appreciate any help that I can get here.

    Thanks in advance

    Regards

    Sreeraj
    Last edited by sreerajmp; 07-10-2013 at 06:26 AM.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Grouping and Ungrouping Checkboxes

    Change your macros to:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-05-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    7

    Thumbs up Re: Grouping and Ungrouping Checkboxes

    Hey!!

    That really worked.

    Thanks a ton.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1