How to make a Password login screen in excel

[TMO]

Anyone know how I can make a password login screen on excel? I need on
to make my project look more professional.

Please help.

Thanks

 

[Bob Phillips]

Create a userform with a textbox. You can specify the Password property so
that it echoes * back.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[J.E. McGimpsey]

Note, however, that using VBA/Userforms for password protection is
highly insecure compared to XL's built in file passwords (not the
worksheet or workbook passwords, though).

If you're using passwords for your user's convenience (i.e., to keep
them from inadvertently modifying sheet(s)), the userform is a nice
way to go.

If you're using passwords for security, however (i.e,. to control
user access to information or code), *being* professional (as
opposed to looking that way) requires that you not use VBA.

 

[ste mac]

TMO,
I have a spreadsheet written by Dave Hawley.

I think it will do what you want... just post back
if you want me to send it to you...

seeya ste

 

[trickard]

i would love to see dave's spreadsheet

I too am trying to create a username/password so that when a client opens the workbook an expiration date pops up, and if that date has expired then a username/password window pops up enabling them to continue using the program, if wrong then it closes the program completely or kills it.

I currently have an expiration date on mine, but once it expires, it appears the workaround is click on the X, then it asks whether to save workbook, and if you click cancel it comes up saying you have a -3 days left.....and they can continue using the program.....

any advise or samples?

Tony

 

[trickard]

i would love to see dave's spreadsheet

I too am trying to create a username/password so that when a client opens the workbook an expiration date pops up, and if that date has expired then a username/password window pops up enabling them to continue using the program, if wrong then it closes the program completely or kills it.

I currently have an expiration date on mine, but once it expires, it appears the workaround is click on the X, then it asks whether to save workbook, and if you click cancel it comes up saying you have a -3 days left.....and they can continue using the program.....

any advise or samples?

Tony

 

[trickard]

Hi

I am Tony and new to the forum....but needs some help - I wrote a program - pretty big with excel and has a lot of macros, and now trying find better ways of securing it, knowing however some with the experience can hack so i understand. but .....
I currently have an expiration code that works fine, but it appears either the workaround or my code lets someone, once expired, to continue to use by the following.....

once you expire, if you click on cancel it will ask you to save and if you click on cancel again it comes back and tells you that you have like a -3 for example left....

and for the life of me i can not figure that out....any help?????

Tony