XL97: Copying Shapes Cancels Selection of Shape

ID: Q174678

The information in this article applies to:

• Microsoft Excel 97 for Windows

SYMPTOMS

After you copy a shape to another worksheet in Microsoft Excel 97, the shape you copied may no longer be selected.

CAUSE

This problem occurs when the following conditions are true:

• You draw a shape on a worksheet.

      -and-
  

• You select the cells around the shape and copy them.

      -and-
  

• You select the shape.

      -and-
  

• You then paste the cells you copied to another worksheet.

WORKAROUND

To work around this problem, follow these steps:

1. Select the shape.

2. On the Edit menu, click Copy.

3. Switch to the worksheet on which you want to paste the shape.

4. On the Edit menu, click Paste.

NOTE: This method copies only the shape, not the cells around the shape.

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 shapes, click the index tab in Microsoft Excel Help, type the following text:

   shapes,

Additional query words: XL97

Keywords          : xldraw 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: November 5, 1998