Closed Thread
Results 1 to 8 of 8

Password for Dropdown List?

  1. #1
    Registered User
    Join Date
    09-02-2010
    Location
    Selangor, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Password for Dropdown List?

    Hello,

    I'm required by my manager to produce password protected dropdown list (I use the data validation feature) for purchase order requester. I have been working on it for 2 days now, I somehow got it but it doesnt seem foolproof; as i often get error message after runnning it a few times.

    Basically, all I need is to come up with a unique password for each name for listed in the "Requester". Whenever I click on it, it will prompt me to enter password.Different names requires different password, otherwise it will return as a blank cell.


    I really appreciate if any of people here can help me with this, as I'm new to Excel programming. Also, kindly show me the steps how to edit data validation if possible.

    Please advise,

    Thank you very much.
    Faiz

    p/s:as attached is the requester list.
    Attached Files Attached Files
    Last edited by phaiz_nova87; 09-03-2010 at 12:50 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Password for Dropdown List?

    Not sure what you are asking for. Are you saying that when Mike choses his name from the dropdown list, you want Excel to ask for a password (unique to Mike)? What happens when the password is properly entered? What happens when it's not?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    09-02-2010
    Location
    Selangor, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Password for Dropdown List?

    My bad for not explaining it in depth. Yes, only these people Bob, Mike, Alan and Pete are allowed to make the request, but they are all have their own password when they need to select their names from the list.

    Say when password for Mike is correctly entered, Mike can use his name,but only his name. He cannot pick others name i.e when he tries to pick Bob from the list, different password will be needed which only Bob knows. Same goes to the others.

    Whenever wrong or no password is entered, the dropdown list will return as a blank cell.


    Thank you
    Last edited by shg; 09-02-2010 at 07:48 PM. Reason: deleted quote

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Password for Dropdown List?

    Something like this put in the SHEET module to watch cell B7, edit the password constants at the top of the macro:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JBeaucaire; 09-02-2010 at 08:02 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  5. #5
    Registered User
    Join Date
    09-02-2010
    Location
    Selangor, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Password for Dropdown List?

    Quote Originally Posted by JBeaucaire View Post
    Something like this put in the SHEET module to watch cell B7, edit the password constants at the top of the macro:

    Please Login or Register  to view this content.
    Thanks alot JBeaucaire! It works like a charm. Can't stress enough how grateful I am for this. Hopefully I'll just be as good in the near future and could later offer help to other people.

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Password for Dropdown List?

    Quote Originally Posted by phaiz_nova87 View Post
    Hopefully I'll just be as good in the near future and could later offer help to other people.

    Well, that's the goal ultimately. Welcome to the village.

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  7. #7
    Registered User
    Join Date
    08-29-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Password for Dropdown List?

    Hi,

    I have the same problem but was unable to use the code to match to my data set and i get an error "Complile error - Variable not found"
    The error point to
    Private Sub Worksheet_Change(ByVal Target As Range)

    Please help.

  8. #8
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Password for Dropdown List?

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.


    In your new thread, be sure to attach your workbook so others can see and help debug the error you're receiving.

Closed 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