Thread: Protect Code
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Paul B[_7_] Paul B[_7_] is offline
external usenet poster
 
Posts: 73
Default Protect Code

Just to add to the last post, this password can be hacked by third party
software, but it will keep "most" people form getting to your code
"Paul B" wrote in message
...
JC, To protect the VBA project, from your workbook right-click the
workbook's icon and pick View Code. This icon is to the left of the "File"
menu this will open the VBA editor, in the left hand window right click on
your workbook name and select VBA project properties, protection, check

lock
project for viewing and set a password. Press Alt and Q to close this

window
and go back to your workbook and save and close the file
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

"JC" wrote in message
...
Hi...

I've written loads of juicey code but want to protect it
from users hitting alt+f11 and nicking it? And if I
disabled alt+f11 how would I get back into it...Helk in VB
editor not too helpful...

JC