XL: Odd Dots and Lines in Copied Picture of Dialog Box Frame

Last reviewed: March 27, 1997
Article ID: Q109112
5.00 5.00c 7.00 WINDOWS kbusage

The information in this article applies to:

  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Microsoft Excel versions 5.x and 7.0, if you copy a picture of a dialog box frame when the dialog box is not actually running, objects in the pasted picture will appear in the wrong location and random dots and lines may appear throughout the picture.

MORE INFORMATION

To copy a picture of a dialog frame, do the following:

  1. Run the dialog box, either by running a macro or subroutine that displays the dialog box or by choosing Run Dialog from the Tools menu when the dialog sheet is active.

  2. When the dialog box appears on the screen, press ALT+PRINT SCREEN. This creates a picture of the dialog box in the Clipboard.

  3. Press ESC to remove the dialog box from the screen.

The Clipboard now contains a picture of the dialog box as it appeared when you pressed ALT+PRINT SCREEN. This picture can be pasted into Microsoft Excel, Microsoft Paintbrush, or any other application that supports pasted bitmaps.

Steps to Reproduce Behavior

To see what happens if you copy a picture of a dialog frame when the dialog box is not running, do the following:

  1. On a new dialog sheet, create a dialog box that contains any controls you like.

  2. Select the frame of the dialog box by clicking once in the frame's title bar.

  3. Press and hold down the SHIFT key and choose Copy Picture from the Edit menu.

  4. In the Copy Picture dialog box, set the Appearance option to As Shown On Screen and the Format option to Picture. Choose the OK button to accept the changes.

  5. Activate a new worksheet.

  6. From the Edit menu, choose Paste.

In the image that appears, the caption for the dialog frame will be in the correct place, but almost every other aspect of the image's appearance will be incorrect. Controls may or may not appear; if they do, they will not appear in the correct places. Also, dots and lines will appear throughout the image in seemingly random locations.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 5.00c 7.00 visual basic
Keywords : kbusage
Version : 5.00 5.00c 7.00
Platform : WINDOWS


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: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.