How to enable Copy/Paste on protected work sheet?

[dveeraj]

I have locked all the cells that have coding and protected the worksheet,
How can i allow a user to copy & paste cells these cells together with its
functionality.

Thanks in advance.

 

[Luke M]

The better question is how to DIS-able copy/paste.

Even with worksheet/workbook protection enables, you can copy the cells and
paste them to a new workbook. If you want people to be able to paste into the
protected workbook, don't protect those cells (note that formatting of said
cell could be compromised in this scenario, however.)