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

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

I don't think you can stop people from copying your file.

They could use windows explorer to copy to a new location and nothing you do in
excel can prevent that.

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

--

Dave Peterson

File copying is handled by your operating system and not by XL. The file has
no say in whether it gets copied or not...
--
HTH...

Jim Thomlinson


"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