+ Reply to Thread
Results 1 to 2 of 2

Create Drop Down List w/ Password Protected Options

  1. #1
    Registered User
    Join Date
    07-16-2018
    Location
    NH
    MS-Off Ver
    Excel
    Posts
    1

    Create Drop Down List w/ Password Protected Options

    I am trying to make a form for work that many different employees will have access to and have to sign off on certain tasks. I am able to make a drop down list with each employees name but want to be able to password protect each name so that when it is selected from the drop down list, you are prompted to provide a password before the selection can be made.

    This old thread (link below) explains exactly what I'm trying to achieve however, I am not familiar with coding at all and after trying several times to use the code a user posted in the thread, I have not had success.

    Can someone explain to me how to use the code in a macro? I tried to do a little research on coding in Excel, but with no luck. If someone could dumb this down for me and use the workbook in the original thread to explain, I would greatly appreciate it. Once I understand how it works, I'm confident I'll be able to apply it to my own workbooks.

    /excel-general/744273-password-for-dropdown-list.html

    Thanks!

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Create Drop Down List w/ Password Protected Options

    The entire code goes into the Worksheet module. Right click on the Sheet - View Code. This type of macro fires automatically. For each option in the dropdown, a password has been added(in red)
    Please Login or Register  to view this content.
    Range B7 is the dropdown and were the paswword rules should apply.
    Please Login or Register  to view this content.
    This opens the input box to write the password.
    Finally, this part deals with wrong passwords. If the password is incorrect, it won't give the user access.
    Please Login or Register  to view this content.
    But you will need to password protect the codes as well.
    You can upload a sample file if you need more help.
    Last edited by PaulM100; 07-16-2018 at 08:58 AM.
    Click the * to say thanks.

+ 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. A tweak to a prior thread on Password Protected Drop-down boxes
    By rochester in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2016, 12:29 AM
  2. Create A Form With Password Protected Data
    By jmcconville18 in forum Excel General
    Replies: 1
    Last Post: 06-06-2014, 01:18 PM
  3. Replies: 13
    Last Post: 03-27-2014, 01:50 PM
  4. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  5. How to Create drop down button with options?
    By prodigy06 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2011, 03:17 AM
  6. Create Query from Password Protected Workbook
    By Joy C in forum Excel General
    Replies: 0
    Last Post: 03-25-2011, 05:46 AM
  7. How to create password protected zip file with Excel and VB
    By andienz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2009, 06:13 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