How do I make my Excel table as secure as possible?

I have an Excel table. I want to give it to a business partner, but I need to think about security and licensing.



1. What shall I do?

2. How do I lock up the table against editing in Excel 2007?

3. How can I make sure that the table is used with one user only?

4. Is there something I can do to avoid (or at least limit) number of unauthorized copies?



Thanks a lot guys.How do I make my Excel table as secure as possible?
First of all, there is no fool-proof method to completely secure an MS-Excel workbook. You can use the Protection feature and set a Password, but there are ways of getting around this.



You could add some VBA code to it that would check the Computer-Name and/or the Windows User-Name at the point of opening the workbook, and exit out if it does not match what it thinks there should be there.



.