Excel 2010 password protection

Hi

I have built an app in Excel 2010 and want to distribute it to clients ao that they can't see the VBA code etc. I know that Excel could be cracked by a host of software until 2007.
What options are available to protect my code in 2010?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
patrickabConnect With a Mentor Commented:
murbro,

To protect your VBA code:
When in the VBEditor, right click the workbook name, select ProjectProperties/Protection, add the check mark and enter the password twice, press OK. That is hardish to crack and few people will even attempt it.

Patrick
0
 
dlmilleConnect With a Mentor Commented:
Also suggest distributing as a .xla or .xlam add-in (with the protection patrickab suggested), if it make sense (e.g., it is an app and not a spreadsheet for data entry, etc...)

Dave
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
 
patrickabCommented:
murbro - Thanks for the grade - Patrick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.