+ Reply to Thread
Results 1 to 8 of 8

Sheet Hide and unhide in excel VBA

  1. #1
    Forum Contributor
    Join Date
    09-07-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    114

    Sheet Hide and unhide in excel VBA

    Hi Firends,

    i want hide and unhide sheets in my workbook . some one please help me.

    i have seven sheets in excel. for example first sheet is master sheet, sheets are (Master , A,B,C,D,E,F)

    in my master sheet i have a drop down list , when am selecting "A" in master sheet ,master and sheet "A" should visible and other sheets should unhide

    if i select "B" , then sheet "B" should visible.same like other sheets .

    sorry am not able to attach my workbook because of some problem in excel forum account.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Sheet Hide and unhide in excel VBA

    Try:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    09-07-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    114

    Re: Sheet Hide and unhide in excel VBA

    Hi ,

    i need one more help in this,
    when am selecting one specific drop down i want to see two sheets visible.
    i understand in your code when select my selection in drop down , it will show same tab name in file . but in my condition i want to show one more in visible.

    in my actual drop down i have a country names, like , united states, poland, india, etc..... when am selecting United states i want to see united states tab with one more tab that "W-9 From" can you please help in this..
    thanks in advance.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Sheet Hide and unhide in excel VBA

    I'm not clear on what you want.

    When you choose "United States" from your dropdown, which two worksheets should be visible?
    When you choose "Poland" from your dropdown, which worksheets should be visible?

    Attaching a sample workbook might help...

  5. #5
    Forum Contributor
    Join Date
    09-07-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    114

    Re: Sheet Hide and unhide in excel VBA

    Hi
    i have a work book that contains sheets . sheets names are home,united states, India, Poland, China, W - 9 from etc....

    these are the sheets , my drop down in home sheet .
    1. when am selecting United states in drop down then "home sheet" and "united states sheet" and "W-9 from sheets" should visible.
    2. when i select china . china sheet only visible
    3. when i select Poland . poland sheet only visible
    same like other country.

  6. #6
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Sheet Hide and unhide in excel VBA

    So, you ONLY want to make the additional sheet ("W-9 from sheets") visible if "United States" is selected?

    Add the line in red:
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    09-07-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    114

    Re: Sheet Hide and unhide in excel VBA

    Thanks guru.
    This is really awesommm...........

  8. #8
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Sheet Hide and unhide in excel VBA

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.

+ 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 and unhide Sheet according to a1 value
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-11-2014, 09:03 AM
  2. [SOLVED] Hide and Unhide one sheet
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2012, 01:55 PM
  3. Hide and Unhide sheet
    By svirgo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-23-2012, 08:11 PM
  4. sheet hide/unhide
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2010, 03:52 AM
  5. unhide sheet, copy data, hide sheet - screenupdate = false
    By titus.hanke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2008, 02:46 PM
  6. Hide/Unhide a Sheet in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 10-31-2007, 09:35 AM
  7. Replies: 5
    Last Post: 02-08-2005, 01:06 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