Excel - protecting VBA code, ".exe"?

[Eytch]

I have long since forgotten how to make an excel file executable. I can't find what I'm after in "help". Any suggestions for the best way to protect my excel VBA code from viewing or editing? Would saving it as an executable file do the trick?

Thanks,
Eytch

 

[fredericofonseca]

you can protect the project through a password (VBE editor, project properties), but its very easy to crack.

If this is not a solution then you will need to convert your VBA code to VB and create a normal executable with it.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[fumei]

In other words, you can't save your Excel VBA as an executable file, but you can make a VB executable that do the same things. You need VB to do that.

Gerry
My paintings and sculpture