Consulting

Results 1 to 4 of 4

Thread: Solved: Passwords part 1

  1. 01-12-2012, 11:02 AM #1
    Sir Babydum GBE
    Sir Babydum GBE is offline
    VBAX Mentor Sir Babydum GBE's Avatar
    Joined
    Mar 2005
    Location
    Cardiff, UK
    Posts
    499
    Location

    Solved: Passwords part 1

    Hi, long time no see

    I have a hidden sheet with a table of user names and passwords.

    Each user has his own sheet in the workbook.

    I want to create a User Interface that requires the user to select his name form a list in A1. When he does a password box should come up. If he gets it wrong then he doesn't get into his sheet.

    But, I also would like it so that I (or the manager) can use a master password to get in.

    Qu'il est possible?
    Have a profound problem? Need a ridiculous solution? Post a question in Babydum's forum
    Reply With Quote Reply With Quote
  2. 01-12-2012, 12:59 PM #2
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Welcome back.
    Here's a first attempt for feedback!
    Attached Files Attached Files
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  3. 01-12-2012, 02:01 PM #3
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    A bit neater
    Attached Files Attached Files
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  4. 01-14-2012, 12:39 PM #4
    Sir Babydum GBE
    Sir Babydum GBE is offline
    VBAX Mentor Sir Babydum GBE's Avatar
    Joined
    Mar 2005
    Location
    Cardiff, UK
    Posts
    499
    Location
    Quote Originally Posted by mdmackillop
    A bit neater
    Neater, brilliant, and exactly what I need.

    Thanks so much! Love you!
    Have a profound problem? Need a ridiculous solution? Post a question in Babydum's forum
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules