XL97: Copying Shapes Cancels Selection of Shape

Last reviewed: January 7, 1998
Article 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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For more information about shapes, click the index tab in Microsoft Excel Help, type the following text:

   shapes,

and then double-click the selected text to go to the "shapes" topic.


Additional query words: XL97
Keywords : xldraw
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug
Solution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 7, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.