![]() |
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