Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide VB Macro Code
Hi,
I have created one application using VB Macros and Forms in XL. Now I have to submit it to the client. Before doing so, I need to hide the VB code. That means when I click "Tools \ Macro \ Visual Basic Editor", my macros and its code should not be visible to any body. How to achieve it and how can I make them visible again. Thanks in advance Sridhar P -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide VB Macro Code
You can password protect your project, but remember that
VBA project passwords can be broken using hex editors. To password protect, while in VBE go to Tools VBA Project Properties Protection tab. HTH Jason Atlanta, GA -----Original Message----- Hi, I have created one application using VB Macros and Forms in XL. Now I have to submit it to the client. Before doing so, I need to hide the VB code. That means when I click "Tools \ Macro \ Visual Basic Editor", my macros and its code should not be visible to any body. How to achieve it and how can I make them visible again. Thanks in advance Sridhar P -- Message posted via http://www.officekb.com . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide VB Macro Code
In Visual Basic Editor, In Project Expolere, right click on your project
and chose VBA Project Properties. Click on Protection Tab. Check the box 'Lock Project for Viewing' and enter your password. Save the project. Close the file and open again. You can see that the macros / code can not be seen unless you enter correct passowrd. (However there are VBA Password Recovery programs available, and if your client has bought such one, he can crack the password and view the project.) Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or VB code to hide and unhide Label box | Excel Discussion (Misc queries) | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
hide code does not hide | Excel Discussion (Misc queries) | |||
Macro/code to hide rows | Excel Worksheet Functions | |||
can you hide macro code?? | Excel Programming |