PDA

View Full Version : [SOLVED] Disable worksheet copy



The Tamer
11-05-2004, 03:19 AM
Hi


I've managed to disable most aspects of copy and paste, but I want to know if it's possible to disable the copying of a worksheet into a new workbook? Or perhaps there is a workaround? Doesn't have to be 100% fool-proof, but it will deter most of my spreadsheet attackers!!

Thanks

Damian

Jacob Hilderbrand
11-05-2004, 04:45 AM
You can protect the workbook and that will stop any worksheet from being moved or copied.

Jacob Hilderbrand
11-05-2004, 04:47 AM
From the Worksheet Menu Bar select Tools | Protection | Protect Workbook. Make sure the box for Structure is checked. Then put in a password.

Just know that this protection is really weak and if someone wants to crack the password it would be very easy. But this will probably stop 99% of people that use Excel.