+ Reply to Thread
Results 1 to 9 of 9

Password for Items in a Dropdown List

  1. #1
    Registered User
    Join Date
    12-17-2020
    Location
    Bowling Green, KY
    MS-Off Ver
    2019
    Posts
    5

    Password for Items in a Dropdown List

    Hello, I am having trouble creating a macro that password protects each individual item in my drop-down list. I would like each option in the drop-down to have a unique password to access the data.

    This would save me a lot of time in sending out one file to four people versus four different files. Does anyone have a solution to this?

    I appreciate any help!!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    222

    Re: Password for Items in a Dropdown List

    hi ceceley, you sent a file but i cannot see any dropdown boxes, can you explain a bit more your requirements

    scouse13

  3. #3
    Registered User
    Join Date
    12-17-2020
    Location
    Bowling Green, KY
    MS-Off Ver
    2019
    Posts
    5

    Re: Password for Items in a Dropdown List

    The dropdown is located in Cell A5. For whatever is chosen from the dropdown in A5, I would like a password to be required contingent on that dropdown. Please let me know if that makes sense.

  4. #4
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    222

    Re: Password for Items in a Dropdown List

    It makes sense apart from the fact there is not a dropdown box in A5, from your attachment you have 2 sheets, tables and variences, all information looks to be inputted manually with no code to link it? tables lists different departments, and the varience sheet shows data monthly by various means, are you asking for, 1) the user chooses his/her department and can view the data relevant to that department and cannot view another department because that will be protected,2) is all the data for all departments entered on one sheet or will there be a different sheet for each departments data?

    I will help you sort it if the above is what you want, but please give as much information as possible of what you would like to achieve

    scouse13

  5. #5
    Registered User
    Join Date
    12-17-2020
    Location
    Bowling Green, KY
    MS-Off Ver
    2019
    Posts
    5

    Re: Password for Items in a Dropdown List

    Oh I see your question. In my real file, I have data pulling from one large database with nested if statements based on the dropdown's chosen department.

    I did not include any of that in the sample file because it is confidential data, and the data itself is really not pertinent to the issue. I have no issue linking the data. I just need to figure out a way to password protect each drop down. In my real file, there is code in all of the data cells. The code links to a "Raw Data" sheet that I export from a database.

  6. #6
    Registered User
    Join Date
    12-17-2020
    Location
    Bowling Green, KY
    MS-Off Ver
    2019
    Posts
    5

    Re: Password for Items in a Dropdown List

    I can upload a new sample file if the data part needs to be more similar to my real file.

  7. #7
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    222

    Re: Password for Items in a Dropdown List

    Hi Ceceley, sorry for the delay in getting back to you, find attached file, hopefully this is what you require.

    Scouse13
    Attached Files Attached Files

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,489

    Re: Password for Items in a Dropdown List

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  9. #9
    Registered User
    Join Date
    12-17-2020
    Location
    Bowling Green, KY
    MS-Off Ver
    2019
    Posts
    5

    Re: Password for Items in a Dropdown List

    Scouse13,

    This is perfect! Thanks so much.

+ 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. Replies: 7
    Last Post: 11-21-2016, 04:40 PM
  2. [SOLVED] Dropdown list with password for a whole column
    By pol04 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2015, 07:53 PM
  3. Replies: 1
    Last Post: 03-18-2014, 02:19 PM
  4. Problem getting conditional formatted dropdown list items to keep their formatting in list
    By scottatbuckman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2014, 02:39 PM
  5. [SOLVED] Password for Dropdown List?
    By phaiz_nova87 in forum Excel General
    Replies: 7
    Last Post: 08-29-2013, 01:25 PM
  6. Replies: 21
    Last Post: 12-02-2009, 03:27 PM
  7. Replies: 10
    Last Post: 03-19-2007, 11:30 PM

Tags for this Thread

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