While doing protection, uncheck "Select Locked Cells". Also give some password, Now no one will able to select the cells and hence will not be able to copy it.
Copy a protected excel file
Anonymous
How can I protect and prevent an extensive excel template from being copied to a blank excel spreadsheet? I have protected each tab and the workbook but can still copy to another spreadsheet.
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} vote
Answer accepted by question author
-
Anonymous
2014-08-28T23:25:24+00:00