+ Reply to Thread
Results 1 to 3 of 3

Hide/unhide sheets based on drop-down menu

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    141

    Hide/unhide sheets based on drop-down menu

    Hi All
    I need a simple macro to Hide and unhide the available sheets in one workbook.
    in the Worksheet called Arin, 1st sheet is named as "Data sheet" ,2nd is "Apple",3rd is "Orange",4th is "Banana" (2nd,3rd and 4th sheets are.

    in Data sheet "A1" I have a drop down.from that drop down if I choose Apple then the sheet called Apple should UN-hide (rest all 2 sheet Orange & Banana should be in Hidden mode)
    in same way it should work for "Orange" & "Banana" sheet.
    if i choose blank in A1 of Data sheet then all 3 sheet should got hide.

    If anybody can help me it will be a gr8 help.

    Regards
    Arin

  2. #2
    Forum Contributor
    Join Date
    12-14-2013
    Location
    Tilburg, Nederland
    MS-Off Ver
    Excel 2010
    Posts
    256

    Re: Hide/unhide sheets based on drop-down menu

    On the Data sheet ad macro:
    Please Login or Register  to view this content.
    Last edited by G e r a r d; 02-16-2016 at 05:21 AM.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Hide/unhide sheets based on drop-down menu

    FWIW:

    Please Login or Register  to view this content.

+ 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] Hide/Unhide Worksheets based on drop down
    By Kerplunk1039 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-09-2015, 04:02 PM
  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. [SOLVED] VBA macro to hide/unhide particular worksheets on selection from drop-down menu
    By lealea1982 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2014, 09:51 AM
  4. Replies: 10
    Last Post: 09-17-2013, 10:36 AM
  5. Replies: 1
    Last Post: 02-01-2013, 03:06 PM
  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. Excel 2007 : Hide Sheets using drop-down menu selection
    By SgtGrayMatter in forum Excel General
    Replies: 2
    Last Post: 03-18-2010, 01:29 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