Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting VB
Hi There, How do I password protect somebody from accessing the VB in a my workbook? Kind Regards D *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting VB
In the VBA Editor, go to the Tools menu, choose VBA Project Properties and
then the Protection tab. There, check "Lock project for viewing" and assign a password. Do note, however, that the password protection is notoriously weak. I use VBAKey from Passware and can get into any VBA project in a matter of 2 or 3 seconds. If your code has propriety or other value, you would be MUCH better off taking the code out of the workbook and putting it into a COM Add-In. Since a COM Add-In is compiled to machine code as a DLL and you distribute only the DLL to the end users, source code is never distributed so security/password protection is not an issue. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Darin Kramer" wrote in message ... Hi There, How do I password protect somebody from accessing the VB in a my workbook? Kind Regards D *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
Protecting Formulas | Excel Discussion (Misc queries) | |||
protecting... | Excel Discussion (Misc queries) | |||
Protecting VBA Macros | Excel Programming | |||
Protecting buttons with VB code rather than protecting sheets/books? | Excel Programming |