View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
 
Posts: 123
Default Hide VB Macro Code

In Visual Basic Editor, In Project Expolere, right click on your project
and chose VBA Project Properties. Click on Protection Tab. Check the box
'Lock Project for Viewing' and enter your password. Save the project.
Close the file and open again.
You can see that the macros / code can not be seen unless you enter
correct passowrd.

(However there are VBA Password Recovery programs available, and if your
client has bought such one, he can crack the password and view the
project.)

Sharad



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!