Grouped Drawing Objects Run Separate Macros

MORE INFORMATION

Grouping Objects

1. Select the circle.
   
   NOTE: If you assigned a macro to the circle, hold down CTRL, and then click the circle.
2. Hold down SHIFT, and then click the rectangle.
   
   NOTE: If you assigned a macro to the rectangle, press CTRL+SHIFT as you click the rectangle. In Microsoft Excel for the Macintosh, press COMMAND+SHIFT as you click the rectangle.
   
   This step selects both objects on the worksheet.
3. If the Drawing toolbar is not visible, point to Toolbars on the View menu, and then click Drawing.
4. In Microsoft Excel 97 or Microsoft Excel 98, click Draw on the Drawing toolbar, and then click Group. In Microsoft Excel 5.0 and 7.0, click Group Objects on the Drawing toolbar.
   
   The two objects are grouped.

Ungrouping Objects

1. Select the group.
   
   NOTE: If you assigned macros to the objects in the group, press CTRL as you click any object in the group.
2. If the Drawing toolbar is not visible, point to Toolbars on the View menu, and then click Drawing.
3. In Microsoft Excel 97 or Microsoft Excel 98, click Draw on the Drawing toolbar, and then click Ungroup. In Microsoft Excel 5.0 and 7.0, click Ungroup Objects on the Drawing toolbar.
   
   The two objects are ungrouped.