Prevent edit or copy in worksheet and workbook

Copper Contributor

  I am attempting to protect my spreadsheet from all others but I need to send it out. I turned on protection of the worksheet and the workbook but I can still select groups of cells and select copy and start a new spreadsheet and paste.  Is it possible to let people move around in the sheet without allowing them to copy all my work?

1 Reply

Hi Bill,

 

When you start to protect the worksheet, uncheck the top two options in the Protect Sheet dialog box, this will prevent users from select any cell so that they will not able to copy them.

 

Protect Sheet.png

 

 

But, there is a trick can be used to copy cells through Name Box.

However, that's the most you can do.