You'd have to write some COM object or .dll to compile the code so that it was
undecipherable (beyond me).

Or you could protect the project.
Inside the VBE
tools|vbaproject properties|protection tab

Be aware that this can be broken, too--but probably not by the casual user.

dayanand108 wrote:

I have a user form with some controls and their code (macro)
when I send the file another, he can see the macro and it is the
editable

what are the tools or way to compile the macro thus no one can see the
code like a exe

--
dayanand108
------------------------------------------------------------------------
dayanand108's Profile: http://www.excelforum.com/member.php...o&userid=25464
View this thread: http://www.excelforum.com/showthread...hreadid=401440

--

Dave Peterson