+ Reply to Thread
Results 1 to 2 of 2

Request password from a dropdown list selection

  1. #1
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    Request password from a dropdown list selection

    Hello,

    I'm looking for a way that can create different passwords based on different selection of the dropdown list. For example,

    If dropdown list contain 3 different people: Chad, Jenny, Lori, these people will have their own password set up for them.

    The main point to do this complicated request is because I don't want other people be able to see other people's customers. So If I am Chad, I open a workbook and use dropdown list to choose my name then excel workbook will ask me to enter my password then I can work on the workbook when it only show my customer.

    I'm open for other suggestion.

    Thanks.

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Request password from a dropdown list selection

    hi,
    Roy UK has a very useful solution (password form6). see if it helps you.
    http://www.excelforum.com/excel-gene...he-sheets.html
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make same selection for multiple drop down list and clear all for all dropdown list
    By salomip13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2014, 01:34 PM
  2. [SOLVED] Password for Dropdown List?
    By phaiz_nova87 in forum Excel General
    Replies: 7
    Last Post: 08-29-2013, 01:25 PM
  3. Cull dropdown list options based on selection in another dropdown
    By Kiffar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 01:53 AM
  4. Request of Password on different selections of Drop down list
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-01-2011, 05:35 PM
  5. Dropdown list key selection
    By TrevorM in forum Excel General
    Replies: 1
    Last Post: 10-03-2005, 03:05 PM

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