+ Reply to Thread
Results 1 to 2 of 2

Hide multiple sheets from a list if a specific word is used.

  1. #1
    Registered User
    Join Date
    06-11-2014
    Posts
    1

    Question Hide multiple sheets from a list if a specific word is used.

    Gooooood morning all,

    Cell E3 contains a drop down list with several category in it (for reference worksheet a,b,c,d,e....)
    I'd like to be able to hide/show worksheets when a category is selected e.g.

    If Worksheet A is selected from the list B,C,D & E are hidden.
    If Worksheet B is selected from the list A,C,D & E are hidden.

    Would anyone able to produce a bit of VB that can fix this issue, I've tried to do it but with little success,

    Thanks in advance,

    Andrew

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Hide multiple sheets from a list if a specific word is used.

    Put this in ThisWorkBook module.

    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] Show / Hide specific sheets per username
    By byte in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-10-2014, 06:04 AM
  2. hide columns if a cell has a specific word
    By tlacloche in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-17-2014, 08:06 PM
  3. [SOLVED] hide specific columns on multiple sheets with protected cells when workbook is closed
    By jrosko1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2013, 03:00 PM
  4. Collate a list of unique items only from multiple sheets into specific categories
    By Boyler_Room in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2013, 08:05 PM
  5. Hide sheets for specific users
    By Robert1986 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2007, 06:11 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