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