Protecting / Hiding the Code

[DBAL]

Hey everyone, I need to find out how to hide the VB code
behind an Excel Workbook. Is it possible to protect it
via password? Can the code be made inaccessible to the
users? Please advise

DBAL

 

[Frank Kabel]

Hi
in the VBA editor right-click on your project name, choose VBA
properties and assign a password.

Note: This kind of protection is very weak. There's no way to really
protect VBA code.

 

[Chip Pearson]

In VBA, go to the Tools menu, choose VBA Project Properties then
the Protection tab. There, check the "Lock project for viewing"
option and enter a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[DBAL]

Thanks a million. When I was in there looking at what
Frank said I saw that. Thanks again! It works.

 

[DBAL]

Thanks alot man. That was the ticket! DBAL

-----Original Message-----
Hi
in the VBA editor right-click on your project name, choose VBA
properties and assign a password.

Note: This kind of protection is very weak. There's no way to really
protect VBA code.

--
Regards
Frank Kabel
Frankfurt, Germany



.