+ Reply to Thread
Results 1 to 3 of 3

Hide/expand a group of worksheet excel 2010

  1. #1
    Registered User
    Join Date
    03-24-2013
    Location
    michigan
    MS-Off Ver
    Excel 2013
    Posts
    6

    Hide/expand a group of worksheet excel 2010

    Hello,
    I have a workbook with worksheet like 2a, 2b, 2c, 2d, 2e, 3a, 3b...etc
    Is it anyway i can make a tab which will hide a group of worksheet (like 2a,2b....2e) together and unhide all the worksheet with another click on it?
    Please help becasue i got too many worksheet to show in the bottom..
    thank you

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852

    Re: Hide/expand a group of worksheet excel 2010

    Ideally you would find a way to reduce the number of sheets...

    If not, You can use code to Hide/Show your tabs

    Create a tab just for hide/unhide sheets.

    In this tab you could have shapes with macros assigned to them to get the tabs you want.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  3. #3
    Registered User
    Join Date
    03-24-2013
    Location
    michigan
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Hide/expand a group of worksheet excel 2010

    thank you for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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