Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
jump to active cell in other sheet . mongkolkorn Excel Discussion (Misc queries) 12 June 19th 07 08:30 PM
Combining data from cells from several excel sheets to a new sheet Rik Excel Discussion (Misc queries) 4 February 22nd 06 10:16 AM
Adding comments to unprotected cell in a protected sheet Dave Excel Discussion (Misc queries) 3 February 8th 06 11:59 PM
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 02:50 AM
Copy text from same cell on every sheet to title sheet? Jon Excel Discussion (Misc queries) 2 February 9th 05 04:11 PM


All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"