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