Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to protect a worksheet from being copied to another worksheet
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??? |
#2
|
|||
|
|||
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 -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=400733 |
#3
|
|||
|
|||
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??? |
#4
|
|||
|
|||
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. 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??? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protection of worksheet when copied and pasted. | Excel Worksheet Functions | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
How do I protect a worksheet from being opened inside a workbook | Excel Discussion (Misc queries) | |||
IF WorkSheet1 A1=1 then put value of WS1 B2 in WS2 C3 else donothi | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |