+ Reply to Thread
Results 1 to 2 of 2

Element deactivation on a list

  1. #1
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    Element deactivation on a list

    I have a list of elements and I would like to deactivate one of them. I do not want to erase it from the list I just want not to be able to choose it when someone tries to do it.

    Is there any way to do it?

    Thank you in advance

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,739

    Re: Element deactivation on a list

    Do you mean a Data Validation cell with the list option? No type of list allows specific items to be visible but disabled. It is possible to disallow selection of particular items with macros. The strategy is to use the Worksheet_Change event, and check to see if that cell has been changed to a disallowed value. If you, you change the value back to a default value.

    If you post your file and describe in more detail I can provide more detailed information.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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: 12
    Last Post: 01-14-2014, 01:56 PM
  2. List of 15 elements, need to generate all 6 element combinations.
    By j4c0b5m17h in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2013, 02:11 PM
  3. If I filter a 33000 element list down to, say, 800.....
    By jazaddict in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2013, 08:30 AM
  4. Copy comment from list element to another cell
    By IBMiGuy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2011, 04:21 PM
  5. Find 7th largest and smallest element in unsorted list
    By cpadude in forum Excel General
    Replies: 2
    Last Post: 06-24-2008, 05:22 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