If you go to tools, protection, protect sheet and then de-select the
checkboxes for "select locked cells" and "select unlocked cells" put a
password in so that you can undo it later (ensure the protect worksheet check
box at the top of the box is highlighted) then click ok. This should do what
you're after!

"SurvivorIT" wrote:

I have an excel worksheet protected also the workbook is protected.
But ounce you highlighted all the worksheet then press right click & choose
copy, all information can be copied to a new worksheet!!!

So how a protected worksheet can be protected from being copied to a new
worksheet???