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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to protect macro cointained Worksheets and workbooks by using 6
Must I use IRM to protect an entire workbook? 1
Protect Worksheet to share with older versions of excel 2
password protect copies of workbooks 1
Macro to Protect the Whole Workbook and Allow Range Edits 2
how to protect data/file excel 1
Protect part of pivot table 1
Protecting all worksheets of a workbook 14

Top