+ Reply to Thread
Results 1 to 11 of 11

Hide Used Items in Drop Down List across multiple sheets

Hybrid View

  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Hide Used Items in Drop Down List across multiple sheets

    Probably best as a new thread. I'm haven't been here much for a few days... so you'll get an answer quicker with a new thread.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  2. #2
    Registered User
    Join Date
    01-18-2024
    Location
    Moon
    MS-Off Ver
    365
    Posts
    2

    Question Re: Hide Used Items in Drop Down List across multiple sheets

    Glenn,

    How can you modify this to use in any column or cell?

    It forces use in only C column. I am guessing it has something to do with the offset function in the define names?

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Hide Used Items in Drop Down List across multiple sheets

    Quote Originally Posted by mkodysz View Post
    Glenn,

    How can you modify this to use in any column or cell?

    It forces use in only C column. I am guessing it has something to do with the offset function in the define names?
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #1 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Hide/Unhide Sheets based on drop down list
    By toci in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-01-2016, 08:06 AM
  2. Hide Used Items in Drop Down List
    By fffleague15 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2015, 12:10 PM
  3. Replies: 0
    Last Post: 04-22-2014, 11:03 PM
  4. Unhide or hide sheets based on drop down list value - need help combining these two macros
    By kstrick99999 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2012, 06:07 PM
  5. [SOLVED] Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-25-2006, 02:55 PM
  6. Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2006, 05:20 PM
  7. [SOLVED] Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2006, 02:45 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