May 25 2018 11:34 AM
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?
May 25 2018 11:41 PM
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.
But, there is a trick can be used to copy cells through Name Box.
However, that's the most you can do.