VBA Password not working

[gjjh25]

How do i set a password on VBA so it cant be opened without the password?

I Have a spread sheet and at the moment i have done Alt + F11, I then right click on the work book and in the properties select protection and enter a password, But when i try to Alt +F11 again it just lets me straight in without asking for a password?

[jeffreybrown]

Try...

Alt + F11
Highlight VBAProject on left side of screen
Tools >> VBAProject Properties >> Protection tab
Check >> Lock project for viewing
Enter password >> confirm password >> Ok
Alt + Q and then reopen the VBE Alt + F11
Double click on VBAProject left side of screen and you should be prompted for a password

http://www.ozgrid.com/VBA/protect-vba-code.htm

[royUK]

You need to save & close the workbook as well. On re-opening the password prompt should work

[gjjh25]

Hi

yes that is similar to what i was doing and for some reason it doesn't work?

[jeffreybrown]

Make sure you save, close & reopen the workbook as RoyUK has pointed out...

[gjjh25]

Hi No I have tried that too and it still wont work?

[gjjh25]

I have just tried this and checked it again, I have put the password in saved it on the vba page saved on the spread sheet page and then re checked on the vba code the password is still there.

When i then close and open it, if i go to properties there is no password on the protection tab?

[shg]

Just so we're clear ...

You password-protect a VBA Project in a workbook, not the VBE. So you select a particular project in the Project Explorer window, apply a password, then save, close, and reopen the workbook.

You can still open the VBE and view unprotected projects, but if you select the protected VBA project, you'll be prompted for the password.

[john55]

hi,
do you have any code in yr wkb? a userform, a combobox or something?
try to add something and do what jeffrey said.

[gjjh25]

i will try this again.

[tryamamoto]

I had the same problem as gjjh25.
Adding a bit of code resolved the problem.
Thanks john55!