Getting Started with Tab Hound [3 of 3] - Excel Campus

Getting Started with Tab Hound [3 of 3]

This is the 3rd installment of Getting Started with the Tab Hound Add-in series.  This page contains a few videos that will help you get the most out of the add-in.

Filter Tab Colors

The color tiles below the sheet list represent all the tab colors in the active workbook.  Clicking on any of these tiles will filter the sheet list for tabs of that specific color.

Sort Sheets Alphabetically A-Z

Sort the sheet list in alpha-numeric order.  This does NOT change the order of the sheets in the workbook.

Select Sheets Button

Select one or more sheets in your workbook.  This is a fast way to select multiple sheets based on a search or filter criteria.  Want to select all the green colored tabs in your workbook to a formula or page layout settings?  Click the green color tile filter, then click the Select Sheets button.

Go To First or Last Sheet Button

These simple buttons take you to the first or last sheet in the workbook.  Keyboard shortcuts Alt+F (go to first) and Alt+L (go to last)

Protect & Unprotect Sheets Button

Protect and unprotect multiple sheets at the same time.  You can enter a password when protecting sheets.

What’s Next?

You can view the other Getting Started pages in this series:

You can also checkout the full online help page to see all these videos.

Please leave a comment below or contact me directly (jon@excelcampus.com) with any questions.

Click Here to Leave a Comment Below 16 comments
Nick Lewis - November 15, 2017

Jon, I love your products, but I am having a problem with the TOC tab. I have a workbook with about 40 tabs on my corporate network. Most of those tabs are chart sheets. Wherever there is a chart, the link fails and gives me this error: “Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.” These charts are all directly linked to tabs in the same workbook. End result is that 2/3 of the links in the TOC fail. Any ideas?

Reply
Mohammad - November 6, 2016

any possibilities to have a copy of the commands to another ribbon tabs ?

Reply
    Jon Acampora - November 14, 2016

    Hi Mohammad,

    The only other place you can place the Tab Hound buttons is on the Quick Access Toolbar. Placing the buttons on other tabs requires custom coding. It’s something I might consider in the future. Thank you!

    Reply
John Lawler - November 3, 2016

Very useful add-in. Two comments: 1) No sheets appear on Tab Hound list of sheets. They all do appear
once I select one of the move commands. 2) The very bottom of the Tab Hound box is cut off. The status
line is missing. I am running Windows 10/ Excel 2016.

Reply
    Jon Acampora - November 14, 2016

    Hi John,

    I just learned that this was an issue with Excel and it was fixed in the latest update release. You should be able to update Excel/Office to fix the issue. Please let me know if you have any questions. Thank you!

    Reply
Mark Drury - October 9, 2015

Great add in which has helped to navigate around large spreadsheets with ease.

Reply
Dan Franceski - September 22, 2014

(Un)Protect –
Why not indicate which sheets are protected? E.g., in the column that has “Visible” and “HIDDEN”, you could use Bold font for Protected sheets.
That then raises the question of how to display only protected sheets. If it gets complicated using the Bold idea then there could be another column to the right of Visible/HIDDEN that would show “P” or “U”.

Reply
    Jon Acampora - September 28, 2014

    Another great suggestion Dan! The column with P or U would probably be the best approach. I will add it to the list. I’m planning to release an update soon. I can’t promise that this feature will be on there, but there will be some nice enhancements.

    Thanks again!

    Reply
      M Myers - October 9, 2016

      A Protect/Unprotect indicator was the first thing to come to mind, even before I purchased the product. To be able to visually identify status would be a huge time saver.

      Thanks

      Reply
        Jon Acampora - October 11, 2016

        Hi M,

        Thank you again for purchasing Tab Hound. That is a great suggestion and I will add it to the feature list for future updates. Let me know if you think of anything else you would like to see in the product. Thanks again and have a good one! 🙂

        Reply
          Victoria - January 29, 2017

          I see the request for showing the Protected status of a sheet was back in 2014. This post is January 2017 and I just purchased Tab Hound. That enhancement is not included. Will you be adding that any time soon (in 2017)?

          Reply
          Jon Acampora - February 15, 2017

          Hi Victoria,
          Thank you for your purchase. My apologies for not getting back to you sooner. I have not been able to add the feature yet, and not exactly sure when I will be able to add it. Sorry, I wish I had better news. Please let me know if you have any questions. Thanks again!

          Reply
John Thong - September 22, 2014

Sorry for not responding earlier as the videos were blocked due to my organization’s restriction.

Reply

Leave a Reply: