XL97: Protected Worksheet Allows You to Paste Data into Cells

ID: Q218980


The information in this article applies to:


SYMPTOMS

When you protect a worksheet in Microsoft Excel, you are still allowed to paste data into certain protected cells.


CAUSE

This problem occurs when you enable the Locked property on a merged cell and you then protect the worksheet.


WORKAROUND

Do not merge cells in a protected worksheet. An alternative to using merged cells to represent labels is to use a text box.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

You can merge a range of cells into one cell using the Merge Cells command. When you protect a worksheet containing merged cells, you can still paste data into the merged cell using Paste on the Edit menu. However, you still cannot edit the merged cell.

Additional query words: XL97


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

Last Reviewed: March 4, 1999