Excel -Custom Password Form

Prompt user for a username and password when a workbook is open. Lots of uses for this.
Shows how to create the form and determine if user entered correct info.

Category:

Education

Tags:

• Excel
• vba
• visual
• basic
• password
• form
• advanced
• excel
• access
• .net
• programming
• protect
• forms
• powerpoint
• vb.net
• ms
• excell

[ISHITHEGREAT]

One more thing (soz)

how would you make the password come up as stars (*********).

Thanks

[rstcomputer]

@ISHITHEGREAT

Just set the property "PasswordChar" - you can put in any character you want to mask the real character being type. Most people use the "*"

[rstcomputer]

@ISHITHEGREAT

Just set the property "PasswordChar" - you can put in any character you want to mask the real character being type.

[ISHITHEGREAT]

Question?

How would you make the spreadsheet close when you exit the form when entering the Username and Password.

I would appreciate feedback as soon as possible.

Thanks.

[rstcomputer]

@ISHITHEGREAT

Use this code:

Application.DisplayAlerts = False

Application.Quit

[solo2070]

I will be using this in a current project. Thanks for the vid,

[ISHITHEGREAT]

I tried the code but even if i type in the correct password in now it quits.

Any new code to sort this out???

[ISHITHEGREAT]

Thanks for the feedback. :)

[gonzalezluis78]

nice