+ Reply to Thread
Results 1 to 12 of 12

Sheet hide or display

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

    Sheet hide or display

    Hi All
    This time I need a help in my excel workbook to hide or display the sheets.
    What I want in the attached sheet is
    In the first appearance only the sheet called “Process Exceptions” will display, other pages will be in hiding mode,
    Now if I click on “Regular HW” it should display only the page called “Regular HW Region Group”
    From there if I click on “JAPAN”, it should display only the page “JAPAN HW Special Programs”
    From there if I click “BUY & TRY” only the page called “JAPAN Buy and try” will display.

    And it should work as above for all button.
    It would be a great help if anyone can help me to create this and explain me for my future reference.

    Regards
    Arindam
    Arin.xlsx

  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 or display

    Try something like this:
    Please Login or Register  to view this content.
    Assign a macro to each button, specifying the required sheet - for example:
    Please Login or Register  to view this content.

    You may also want to add some code to make all the sheets visible again, to make your development easier:
    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
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    141

    Re: Sheet hide or display

    Hi Olly
    Thanks for your answer.
    It will be a great help if you can edit my excel file for few of the buttons .because I have tried.but it is not working for me.
    I will do the rest.
    Arindam

  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 or display

    Here you are - assigned macros to the first two buttons, as an example:
    Attached Files Attached Files

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

    Re: Sheet hide or display

    In this, my home page Button is not working
    Homepage Button should return me in the page called "Process Exceptions", which is not working while running the macro by clicking any button
    another button is there in the few of the pages like "EMEA HW Special Programs" it should return me "Regular HW Region Group" page.

    If you can help on this I can do the rest.

    Thanks in advance..

  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 or display

    Show me the macro code you assigned to the "Home" button.

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

    Re: Sheet hide or display

    It was hyperlinked.

    One more thing whenever I an using the macro to make all the sheets visible again its take me in the "Tekelec Buy and try" page,
    How to come to "Process Exceptions" page.

    This also can solve my problem to come to home page..
    Last edited by arindamsenaxa; 10-12-2017 at 08:14 AM.

  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 or display

    Remove the hyperlinks, use a macro which calls the SelectSheet macro.

    To 'link' to Home page, just use the home page sheet name in the macro:
    Please Login or Register  to view this content.

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

    Re: Sheet hide or display

    Thanks for your continuous support.

    the last thing what I want to ask you is whenever I an using the macro to make all the sheets visible again its take me in the "Tekelec Buy and try" page,
    How to come to "Process Exceptions" page.

  10. #10
    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 or display

    Add a line to specify which sheet you'd like to activate:
    Please Login or Register  to view this content.

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

    Re: Sheet hide or display

    Thanks A lot...

  12. #12
    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 or display

    Happy to help. 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. Replies: 4
    Last Post: 05-18-2016, 02:37 PM
  2. Hide or Display rows using VBA or without
    By kuntino in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2013, 05:11 AM
  3. Display/Hide chart
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2012, 11:29 AM
  4. Display/Hide chart
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2011, 08:23 AM
  5. Hide cells with no display
    By tondrey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2010, 11:41 AM
  6. Hide or display columns
    By stokie21 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-28-2009, 10:19 AM
  7. row hide/display
    By bforster1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2005, 02:15 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