How to protect coping of excel file?

H

Harshad

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
 
S

Satyendra_Haldaur

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
 
D

Dave Peterson

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.
 
J

Jim Thomlinson

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