Microsoft Knowledge Base

XL5 Err Msg: "Locked Cells Cannot Be Changed" in Dialog Sheet
Last reviewed: March 27, 1997
Article ID: Q108352
5.00 5.00c 7.00 | 5.00 5.00a 
WINDOWS         | MACINTOSH
kberrmsg

The information in this article applies to:

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

SUMMARY

In Microsoft Excel, if you copy cells from a worksheet and then attempt to paste them onto a dialog sheet, you may receive the error message 

   Locked cells cannot be changed
(even though dialog sheets do not contain cells) and the information is not pasted onto the dialog sheet.

NOTE: This problem does not occur when you attempt to paste a drawing or picture object.

MORE INFORMATION

To copy cells in a worksheet and paste them into a dialog sheet, do either of the following:

  • Select an object in the dialog sheet (such as the frame of the dialog box) before you paste the information. When the cells are pasted, they will be pasted as a picture.

    -or-

  • Copy the cells as a picture. Instead of clicking Copy on the Edit menu, press the SHIFT key and click Copy Picture on the Edit menu.

KBCategory: kberrmsg
KBSubcategory:

Additional reference words: 5.00 5.00a 5.00c 7.00
Keywords : kberrmsg
Version : 5.00 5.00c 7.00 | 5.00 5.00a
Platform : MACINTOSH 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
©1997 Microsoft Corporation. All rights reserved. Legal Notices.