XL97: Drawing Object Names Increment Incorrectly

ID: Q160577


The information in this article applies to:
  • Microsoft Excel 97 for Windows


SYMPTOMS

The name of a drawing object that appears in the Name Box appears to increment incorrectly after you draw an object on a worksheet.


CAUSE

When Microsoft Excel names a drawing object on a worksheet, it uses a name that includes a number. This number is incremented by one digit each time you create a drawing object. When you add a drawing object (for example, a rectangle) to a worksheet, Microsoft Excel assigns a name to the object (for example, "Rectangle 1"), which is displayed in the Name Box. When you create another drawing object on the same worksheet (for example, an oval), Microsoft Excel assigns a name that includes a number that is one greater than the number used to name the first object (for example, "Oval 2").

In Microsoft Excel 97, some shapes, such as the line object, do not use a predefined size. Shapes without a predefined size require that you draw the shape with the pointer. If you click a drawing shape on the Drawing toolbar but do not draw the shape, the naming counter is incremented.


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 Drawing objects click the Index tab in Microsoft Excel Help, type the following text

drawing objects
and then double-click the selected text to go to the "Add a circle, square, or other AutoShape" topic.

Additional query words: XL97 drawing objects name increment

Keywords : kbualink97 xldraw
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: October 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.