I need to put a password for a VBA code

[gaftalik]

Hi ,
How can i put a password for a module to be opened?

Many Thanks !

 

[listerheb]

hit Alt=F11 highlight the module then go to tools and VBA project properties. selct the security tab and enter a password

 

[gaftalik]

Hi , i tried that , i inserted a password , saved and exit, tried to access it again it opened without asking for a password, did i miss anything ?
Thank you

 

[listerheb]

oops sorry. did you put a check in the Lock project for viewing box?

 

[gaftalik]

Yeah i did and still not asking for a password after i save and exit !

 

[listerheb]

In your original question you said module. Are you trying to protect the workbook or just the VBA code. Becasue I told you how to protect the VBA code.

 

[gaftalik]

To be frank with you i dont know the difference , but i dont want anybody to see the code inside the module because i saw modules which you needed password for it to open thats what i need.

Sorry if i was not clear

 

[Juan Pablo González]

Did you save the workbook when you entered the password in the VBE the first time ?

 

[ammdumas]

Sounds like the problem I had a while ago. This is from a thread of mine a while ago...

http://www.mrexcel.com/board2/viewtopic.php?t=51477&highlight=

Follow the links and it will show you how to create an input box that does the '****' thing.

 

[gaftalik]

Yes i saved the workbook and yet no password was saved , even if i click on the module and go to the Vba properties under tools , in the protection tab i see the password i typed and the lock project is checked, and still not working