+ Reply to Thread
Results 1 to 3 of 3

A tweak to a prior thread on Password Protected Drop-down boxes

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    US
    MS-Off Ver
    Office 13
    Posts
    1

    A tweak to a prior thread on Password Protected Drop-down boxes

    Back on 9/2/10 a question was asked by phaiz_nova87 about password protecting drop-down boxes. JBeaucaire provided an excellent response. I don't know how to link to it other than mention "excel-general/744273-password-for-dropdown-list.html".

    The code JBeaucaire provided is below - it requires the user to click on their name, and then enter a password in order to go on. The script below refers to cell B7 (which was a location for the drop down box in the sample spreadsheet provided by phaiz_nova87. My question is - Is there a ready way to apply this logic to a number of cells on the same page? I have dropdown boxes in cells U13:V36 for example (a lot of dropdowns, I know!) Can the logic in the script below be relatively easily changed to apply to all of these 48 cells?

    Thank you so much for your time and attention!!!

    Please Login or Register  to view this content.
    Last edited by alansidman; 05-11-2016 at 12:29 AM.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: A tweak to a prior thread on Password Protected Drop-down boxes

    You should be able to just change B7 in the original code to U13:V36
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,309

    Re: A tweak to a prior thread on Password Protected Drop-down boxes

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Call in the cavalry -- need help solving this thread-prior to 2013
    By teylyn in forum The Water Cooler
    Replies: 821
    Last Post: 01-06-2015, 08:01 PM
  2. Replies: 0
    Last Post: 05-19-2014, 10:02 PM
  3. Replies: 2
    Last Post: 07-10-2012, 05:17 AM
  4. Referencing Protected Tables Via Drop Down Boxes
    By bbrian in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-26-2009, 04:20 PM
  5. Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. Replies: 0
    Last Post: 09-05-2005, 10: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