View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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