View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Protecting / Hiding the Code

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" wrote in message
...
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