Just write down "application.cutcopymode=false" in worksheet's deactivate
event.it wud look like this.

Private Sub Worksheet_Deactivate()

Application.CutCopyMode = False


End Sub

"Harshad" wrote:

I have prepared macros cantained xls file which contains some editable
(addable) data, I don't have any problem if anyone can add data. I don't want
others to copy the Entire data and the whole file.

Is their any option rather to protect macro, protect sheet and workbook.
Means to say to protect coping of xls file.

regadrs,

Harshad