ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Able to overwrite locked cell in protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/95032-able-overwrite-locked-cell-protected-sheet.html)

[email protected]

Able to overwrite locked cell in protected sheet
 

I have stumbled across a scenario that allows my users to paste data
into a locked cell on a protected worksheet. If anyone knows a fix I
would appreciate it!

Running Excel 2000 SP-3

1) Create a merged, locked cell and protect the sheet.
2) Copy an unlocked cell to the clipboard
3) Paste the cell into the locked merged cell.

Excel allows the paste!

I cannot paste a locked cell into the locked merged cell.
I cannot type into the locked merged cell.
I cannot paste text (say, from Notepad) into the locked merged cell.
I cannot paste into locked but not merged cells.

I see this behavior whether I lock the two individual cells before I
merge them, or lock the merged cell after the merge.
I see this behavior on any size or shape merge that I have tried.

Problem not limited to my computer -- end users reported this to me.
Problem goes away with Office XP, but an upgrade is not an optoin for
certain computers.

Any ideas on a fix?

Thanks!
Lee



All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com