Protecting / Hiding the Code

D

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
 
F

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.
 
C

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
 
D

DBAL

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

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



.
Click to expand...
 
Top