Sheet Protection

[sohaibj]

I've protected a sheet but anyone can copy from selecting sheet tab and copy it in another file and can make any changes.

How can i prevent it from even doing so

 

[DominicB]

Good moning sohaibj

Yes, Excel's security is not very secure, but they won't be able to paste the sheet back to the original file. Also if a user wants to remove the password a simple Google search will turn up macros that will remove it in seconds.

To answer your original question, some code can be found here that will prevent the user from copying and pasting :

http://www.xcelfiles.com/VBA_Quick13.html

HTH

DominicB