How can I password protect my code?

[Badnames]

One of the workbooks I inherited prompts for a password when someone right clicks on a tab and clicks view code. I'd like to have this happen in another workbook. Does anyone know how I can protect the code?

 

[VoG]

See http://www.mrexcel.com/forum/showthread.php?t=572443

 

[Lewiy]

Open the VB editor, go to Tools>VBA ProjectProperties>Protection. Tick Lock Project for viewing and enter a password. Then save and close your workbook.

 

[prajul89]

Right Click the Module, Select VBAProjecProperty, then Protection TAB give Password and Check that Box that's it!!!

 

[Badnames]

This did not work. I am running excel 2007. I went into view code --> tools --> VBA project properties --> protection checked the box to "Lock project for viewing" and then typed in a password. Saved my file, reopened the tools menu and confirmed that the password was there and the toolbox is checked. Saved my file again and closed out. When I reopen the file the password did not work and I am able to access the code portion. I check under tools and see that the password is blank and the toolbox is unchecked. Any idea why this may be happening?

 

[prajul89]

This did not work. I am running excel 2007. I went into view code --> tools --> VBA project properties --> protection checked the box to "Lock project for viewing" and then typed in a password. Saved my file, reopened the tools menu and confirmed that the password was there and the toolbox is checked. Saved my file again and closed out. When I reopen the file the password did not work and I am able to access the code portion. I check under tools and see that the password is blank and the toolbox is unchecked. Any idea why this may be happening?

So have you forgot the password or what????

I hope you have added your password in both the fields i.e, Password and Confirm Password