View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default Hide VB Source Code

Hi

you can password protect it but it isn't iron clad ..
in the VB Editor, right mouse click on the module, choose VBA Project
Properties, click on the protection tab - tick the lock project for viewing
& type in a password .. then close excel, saving changes, when you reopen it
you can't see the code without knowing the password.

Hope this helps
Cheers
JulieD


"AvalonDave" wrote in message
...
Hi,


Is there any way to hide the VB source code to my macro I create in an

excel
workbook so i can prevent someone from stealing my code?


Thanks,

AvalonDave