Protecting VBA Project with Password

[FM1]

Hello everyone !

How can I protect the VBA project with a password so that the code modules may not be accessed by others.
To be clear, when you open the VBA screen from "TOOLS" "Macro..." there is a project window on the top left side, when you click on the project it shows all the components eg, modules, forms.... I like to prevent that by placing a password so double clicking on the project name or clicking on the "+" next to the project name will prompt the user for a password.

sorry about the long explanation, I will appreciate your help and response.
Searching the help file did not help,

Thanks

 

[pmover]

address your question from within the VBA HELP menu.

I have "crs" at the moment, i'm not at my pc, and cannot recollect the exact menu system commands.

-pmover

 

[msmith]

Hello.

Once you are in the VB Editor, select Tools/VBA Project Properties... then click on the Protection Tab of the dialog that appears. Check "Lock Project For Viewing", enter a password and click OK. When you close the associated workbook then re-open, attempting to access the VBA project, as you described, will prompt for a password.


HTH
Mike