Securing an Excel Spreadsheet

Security is an issue if you're a software developer.

There is always a trade-off between too much security and too little. Too much and you annoy your users and too little and people have a free-for-all with your product. When it comes to securing Excel software or any software someone can always reverse engineer what you've done.

 So the first thing to do is to add a password to your work. Go to the "Review" ribbon and select "Protect Workbook". Give it a nice long password to make it harder to crack. The second thing you can do is obfuscate the code. This means converting it from something that's easy to understand to something that's not. I worked on a tool to do this but never finished it.

 Searching on Google brings up 192,000 entries so someone has also thought about this.
,
Now you need to secure your VBA code by going to Tools - VBA Project Properties, click the Protection Tab and then click the "Lock project for viewing" and enter and confirm your password.