View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 97
Default How to Protect my code without anybody seeing

1) In the Visual Basic window click Tools, VBAProject Properties,
Protection.
2) Make sure the checkbox to lock the project from viewing is checked.
3) Enter your password where required.
4) Make sure you store you password somewhere that you can find it. You can
pay to retrieve the password but, I doubt its cheap.

Adding "Option Private Module" to all modules will prevent users seeing
individual Sub names.



"Terry" wrote in message
...
Hi, I have written a VBA program in Excel 2003. For Protext my right, how
to protect my code? Thank you very much!