Hiding VB code & Securing Code

[Dave Allen]

I need to send out an Excel SS to customers, and need to
protect the IPR of the code and macros.
It has all been done in VB

Does anybody have any ideas how I can protect and secure
this thing?

Obviously I have signed the macros with a Dig Sig. and
password protected the SS, but once the user has gained
R/O access they can save as something else and get access
to the code....

Any thoughts welcome

Dave

 

[Dave Peterson]

Did you mean VBA?

If yes, inside the VBE, you can lock the project.
Tools|VBAProject Properties|Protection tab.
Give it a memorable password and lock the project for viewing.

But it's not really secure. There are password crackers available (minimal
cost) that will open your project.