Sheet Protection

sohaibj

Board Regular
Joined
Jan 28, 2004
Messages
158
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
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,057
Messages
5,545,755
Members
410,704
Latest member
Cobber2008
Top