.xlsm to .exe & Protection of Application

[MSingh]

Hi,

Can someone recommend a good program that can be used to protect .xslm workbook for distribution.

I tried one of the more popular commercial compilers but find its limited in reading activex forms/controls, cannot be used if application requires insert rows etc. & intermittently swithes to manual calculations. Also it adds +/- 2Mb to file size.

Thanks again
Mohamed

[HansV]

I don't think trying to convert a workbook to an executable is a good idea.

For protection against accidental tampering, you can protect the worksheets and if desired the workbook with a password. You can also protect the VBA project with a password.

If you really need to protect your intellectual property, it'd be better to develop your application from scratch using one of the Visual Studio products.

[MSingh]

Thanks Hans.