Article ID: 169957
Article Last Modified on 10/21/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q169957
SYMPTOMS
When you ungroup a set of drawing objects, the name that was assigned to the group still appears in the Name box on the formula bar, and the Name box is in edit mode.
CAUSE
You selected the group name in the Name box on the formula bar before you ungrouped the drawing objects.
WORKAROUND
Click in the worksheet to refresh the Name box.
-or-
Do not select the group name in the Name box on the formula bar when you want to ungroup a set of drawing objects. Instead, select the group in the worksheet before clicking Ungroup on the Draw menu.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
REFERENCES
For more information about grouping objects, click the Index tab in Microsoft Excel 97 Help, type the following text
grouping, drawing objects
and then double-click the selected text to go to the "Group, ungroup, and regroup drawing objects" topic.
Additional query words: XL97 grouped grouping
Keywords: kbbug KB169957