+ Reply to Thread
Results 1 to 2 of 2

Select specific options of dropdown, lock the rest

  1. #1
    Registered User
    Join Date
    07-02-2018
    Location
    Austria
    MS-Off Ver
    Microsoft Office Home and Business 2016
    Posts
    3

    Question Select specific options of dropdown, lock the rest

    Hello,

    I have a dropdown list and I want to lock my sheet. The dropdown list should be PARTLY unlocked, with only certain options in the dropdown list being available to set or even better only showing specific options.
    Is there any way to do that? I know you can lock or unlock a dropdown list as a whole, but I didn't find anything regarding my issue.

    Can anyone help me?

    Thanks!

    BR

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Select specific options of dropdown, lock the rest

    You can use code to set the values allowed for a cell using Data Validation. For example:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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: 6
    Last Post: 12-18-2017, 05:04 PM
  2. Replies: 5
    Last Post: 04-23-2016, 11:34 AM
  3. [SOLVED] Select a specific value from the dropdown list and automatically diverted to another tab
    By alice2011 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2014, 01:52 PM
  4. Replies: 4
    Last Post: 09-10-2013, 02:11 PM
  5. 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
  6. Macro : To find word and Select rest after this cell and delete rest
    By Zortabello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2010, 08:06 AM
  7. Lock cells to select from dropdown only
    By busybeemg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2010, 02:11 AM

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