How to protect a worksheet from being copied to another worksheet

S

SurvivorIT

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???
 
D

dominicb

Good afternoon SurvivorIT

There's a simple answer to this. You can't.

You could try all the fancy tricks in the world, disabling cut, copy
and paste, protecting this, hiding that etc, but all a user needs to do
is run a fairly simple macro to unprotect it, or use the copying trick
you mention. Spreadsheets can be opened without running macros and any
password protected VB project can be opened in literally less time than
it took to protect it.

Excel is not secure, so don't trust it with anything you wouldn't want
other users to see.

HTH

DominicB
 
D

dan

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!
 
D

Dave Peterson

You really can't stop the dedicated copiers.

Worksheet and workbook protection (via tools|protection) is easily broken.
Anything that I would try would rely on VBA and macros/events can be disabled by
the user.
 
Top