VBA code protection in Excel

[Guest]

how can i protect VBA code embedded in Excel, when distribute it to users.
for example, if users click "ALT+F11" to display VBA edit window, and want to
expand the code window, he need input one password, thanks

 

[JulieD]

Hi

in the VBE Window, right mouse click on your project's name (the workbook
name) and choose VBAproject properties .. choose the protection tab, enter
the password in there to password protect it.

Cheers
julieD
"VBA code protection in Excel" <VBA code protection in
(e-mail address removed)> wrote in message
news:[email protected]...

 

[RWN]

In 2k (also in older versions but slightly diff path);
In the VBE;
"Tools->VBAProject-Properties" -Protection tab.

One small word of warning (from sad experience);
If you protect it in one version then try to open it in a prior version
it won't allow you to enter the password.
Also, it is not foolproof.

 

[JE McGimpsey]

As in, there are techniques available to remove VBA protection in
slightly more than a heartbeat.

 

[RWN]

Also, "just when you do make it foolproof, the world invents a better
fool"