How to compile the macro
 

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

How to compile the macro
 

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

How to compile the macro
 

VBA (or even XL for that matter) is not designed to be a secure
environment. About the best you can do is password the project. In
the VBE, make sure the Project Explorer pane is visible (if not, use
View | Project Explorer). Right click on your project and select
{project name} Properties... then select the Protection tab. Password
protect the project.

Two caveats. After you save the file you will be unable to access the
project without the password. The password is good only to keep the
honest and curious away. It is rather easy to break.

Finally, I would strongly recommend you consider distributing your code
as an add-in. For more see

Microsoft Office XP Developer
Building Application-Specific Add-ins
http://msdn.microsoft.com/library/de...l=/library/en-
us/modcore/html/deovrbuildingapplicationspecificaddins.asp
and
Microsoft Office XP Developer
Add-ins, Templates, Wizards, and Libraries
http://msdn.microsoft.com/library/de...l=/library/en-
us/modcore/html/deovraddinstemplateswizardslibraries.asp



--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

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