How to protect coping of excel file?

  • Thread starter Thread starter Harshad
  • Start date Start date
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
 
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
 
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.
 
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
Excel Protection 2
Excel Data Protection Best Practice: AKA: Real Sheet Protection 4
Must I use IRM to protect an entire workbook? 1
Protecting cell formulas in excel 2007 1
Password protected and shared workbook 1
Password Protecting a workbook 2
Saving up to xlsm 1

Back
Top