Password & Login ~~~ Restricting Code Access 1

[Roam2k2]

Hi,
I've got a command button that once clicked asks for the user password and then if correct, performs the specified action. I am currently using a simple Input Box to ask the user for both his/her username and password. Is there a better way to go about this action ?

Also, how do i restrict code access in VBA ? As in, you know how all you have to do is hit ALT+F11, how do i block off that option ? I ask because if you hit ALT+F11 on the form, you can easily see the user's password that would allow you to do a certain action.

Thanks for all your help,
-Roam.

 

[macropod]

Hi Roam,

To restrict access to your vba project, give it a password (Tools|Project Properties|Protection > Lock Project for Viewing (check)> Password (input)> Confirm Password (input)> OK).

Cheers

[MS MVP - Word]

 

[Roam2k2]

Thank you !