+ Reply to Thread
Results 1 to 2 of 2

Username and Password login in MS Excel 2010

  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    Holt
    MS-Off Ver
    Excel 2010
    Posts
    27

    Username and Password login in MS Excel 2010

    hello.
    I am thinking about using ID+password to login into the excel system.
    So let's say I have two text boxes:
    txtbox1 = Username
    txtbox2 = Password

    Button1 = Login

    In the worksheet called "Users" I have two columns:

    User Pass
    John 1212
    Kerry 2323
    Pit 3434
    Tom 4545

    Column1 = User
    Column2 = Pass

    Question is - how to make macro working in such way, that only registered users can log in? And in case if login|password don't match each other it should come up with an error box saying smthing like "Username or password are incorrect"

    I am not well trained on VBA, so your advice will be very helpful.

    With best regards, Vlad.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Username and Password login in MS Excel 2010

    Hi Vlad, welcome to the forum.

    There are quite a few forums and posts on this subject, and even a few example workbooks out there like the 'Passwordbook.zip' file here http://www.ozgrid.com/download/

    A quick google of 'excel vba password multiple users' brings up quite a few discussions on the subject. Just realize that Excel security is not at all secure.

    Hope that helps!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1