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

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
wrote in message
...
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

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.
--
Regards;
Rob
------------------------------------------------------------------------
"VBA code protection in Excel" <VBA code protection in
wrote in message
...
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

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


In article ,
"RWN" wrote:

Also, it is not foolproof.

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

--
Regards;
Rob
------------------------------------------------------------------------
"JE McGimpsey" wrote in message
...
As in, there are techniques available to remove VBA protection in
slightly more than a heartbeat.


In article ,
"RWN" wrote:

Also, it is not foolproof.