Forum Discussion
Prevent edit or copy in worksheet and workbook
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?
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.
