ExcelBanter - 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 ***