Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protect Macro - Compile Error | Excel Discussion (Misc queries) | |||
macro to compile columns on multiple sheets | Excel Discussion (Misc queries) | |||
Macro / Compile Error / Duplicate Declaration | Excel Worksheet Functions | |||
macro compile error | Excel Programming | |||
Excel 97 Macro Compile Errors | Excel Programming |