Results 1 to 11 of 11

Hide/Unhide Sheets based on drop down list

Threaded View

toci Hide/Unhide Sheets based on... 08-31-2016, 04:05 PM
prjt Re: Hide/Unhide Sheets based... 08-31-2016, 04:18 PM
toci Re: Hide/Unhide Sheets based... 08-31-2016, 04:21 PM
toci Re: Hide/Unhide Sheets based... 08-31-2016, 04:32 PM
prjt Re: Hide/Unhide Sheets based... 08-31-2016, 04:38 PM
toci Re: Hide/Unhide Sheets based... 08-31-2016, 04:42 PM
toci Re: Hide/Unhide Sheets based... 08-31-2016, 05:41 PM
toci Re: Hide/Unhide Sheets based... 08-31-2016, 05:25 PM
prjt Re: Hide/Unhide Sheets based... 08-31-2016, 05:57 PM
toci Re: Hide/Unhide Sheets based... 08-31-2016, 06:10 PM
prjt Re: Hide/Unhide Sheets based... 09-01-2016, 08:06 AM
  1. #10
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: Hide/Unhide Sheets based on drop down list

    Nope, still doesn't work. Only works fine if I select "All Divisions". When I select "Financial" it hides and "Region FIN" but it should be visible.
    Also if I select case "Financial" and then "Retail" nothing happens.
    I can't figure out on which principle this code works, I mean, how it's know which Sheets to hide?
    What if I add some new sheets?
    Attached Files Attached Files

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 menu
    By arindamsenaxa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2016, 10:01 AM
  2. VBA Hide/Unhide individual sheets based on selection in drop down menu
    By igullage in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-05-2015, 08:01 PM
  3. Hide/Unhide cells based on drop-down list
    By Savvy25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 02:36 AM
  4. Hide-Unhide rows on multiple worksheets based on value of a drop down list
    By clo2peter in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-10-2014, 08:32 AM
  5. [SOLVED] hide or unhide rows based on text within a drop down list
    By souimet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2013, 01:32 AM
  6. 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
  7. Hide/unhide columns based on the drop down list value
    By vagif in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2012, 02:13 AM

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