How to Protect Data from Copying in Excel

preview_player
Показать описание
How to Prevent Data from Copying in Excel Sheet

This tutorial will help you to prevent data from copying from other users. You can do it with the same way by locking worksheet but you have to make a little change like unchecked the boxes contain select locked cell/ unlocked cells. After that you data are secured.
Рекомендации по теме
Комментарии
Автор

Thanks for explaining in simple video.

gopalakrishnarao
Автор

when the case is to give some user data entry rights while the rest of the data copy protected pls advise

rnpk
Автор

I try to protect looked sheet from copy and paste. (same like this video)

But my problem is, i cant "Allow users to edit ranges".

I dont want somebody to copy my sheet, but i only want them to use unprotect ranges.

HOW?

sarifshafiq
Автор

Nice, but if you open your file with another application as OpenOffice, restrictions are easily bypassed

compassft
Автор

Will this work if I want to lock copy but I want to edit the cell??

carloscardenas
Автор

and then someone simply click right click copy and then he can paste all your work into another excel sheet congrats

MedoXegy