+ Reply to Thread
Results 1 to 4 of 4

Hide/unhide Tabs by color

  1. #1
    Registered User
    Join Date
    01-11-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Hide/unhide Tabs by color

    Good morning.

    I'm new in this forum and I know that probably there is something related to this subject here but I don't have enough time to do a good research and need some help

    I am creating this Excel book that contains everything related to a project but I have too many tabs and I dont need to see them all at the same time.
    So I am trying to create 4 different buttons (Toggle Buttons I think are the best fit) to hide/unhide tabs related to specifics of the project.
    I think that sort them by color is the easiest way than by name since there are too many tabs.

    So I did a trial hiding/unhiding tabs by the tab name, but I still cannot figure how to do it by tab color, so if any one know how to do it I'll very thankful!!

    Ill attach my two files so you can see what I have so far.

    Thank you very much in advance.
    Attached Files Attached Files
    Last edited by angeljdiez; 01-16-2012 at 03:26 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Hide/unhide Tabs by color

    Here's some code to adapt
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    01-11-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Hide/unhide Tabs by color

    Hey Thanks!!

    I ended up with this anyways

    Please Login or Register  to view this content.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Hide/unhide Tabs by color

    Totally different to what you actually asked for! It will work until someone changes the sheet name(s).

    Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.


    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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