Tab Hound Help Page - Excel Campus

Tab Hound Help Page

This is the help page for the Tab Hound add-in.  Here you will find video tutorials for each button and feature in the Tab Hound window.

Please leave a comment below if you still have questions about how to use Tab Hound.  I will be happy to help. 🙂  Thank you!

XL Campus Ribbon

Once Tab Hound is installed the XL Campus tab will appear in the Excel Ribbon.  On this tab you will see the buttons for Tab Hound, Table of Contents, and Flip Back.

Pressing the Tab Hound button will open the Tab Hound window.

XL Campus Tab - Tab Hound Button and Window

Tab Hound Window

The following image is an overview of the features on the Tab Hound window.  Press the Tab Hound button in the XL Campus tab of the ribbon to open the Tab Hound window.

Tab Hound Window Features Overview

 

Video Tutorials

There is a section on this page for each button or feature of Tab Hound. Each section contains a video tutorial for that feature. You can watch all the videos at once in the video below.

Sheet List

The sheet list contains a list of all the sheets in the currently active workbook.  Double-clicking on any sheet will take you to that sheet.

The sheet list is packed with additional features that make it easy to work with your sheets.  Checkout the video for all the features of the sheet list.

Search Box

The search box allows you to filter down the sheet list for any sheet containing your search term.  This is a very fast way to find a worksheet and navigate to it.  You can also use the search box to filter the list, select multiple sheets, and then perform actions on those sheets like hiding and unhiding.

Tab Hound Keyboard Shortcuts

All the buttons in the Tab Hound window have dedicated keyboard shortcuts.  Simply press and hold the Alt key, then press the underlined letter in the button name to press that button with a keyboard shortcut.

You can also open the Tab Hound window and press the Flip Back button with keyboard shortcuts by adding the buttons to the Quick Access Toolbar (QAT).

Checkout the video for all the details.

Custom Keyboard Shortcut and Full Screen Mode

The Tab Hound Window can also be opened with a custom keyboard shortcut.  The following video shows two ways to open Tab Hound with a custom keyboard shortcut and the QAT shortcut.  In the video I also explain full screen mode and how to use the shortcuts in full screen mode.

The macro below can be added to your Personal Macro Workbook.  You can then assign a custom keyboard shortcut to the macro.  I explain more in the video above.  This is an alternate solution to using the shortcut key for the QAT.

Sub Open_TabHound()

  Application.Run "EC_Tab_Hound.xlam!Open_Tab_Hound_Window"

End Sub

 

Flip Back Button

The Flip Back button will take you back to the last sheet you were on.  You can continue to press it to jump back and forth between two sheets.

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.

Stats Bar

The Stats Bar gives you stats about your workbook.  You get the count of how many total sheets are in the workbook, plus the count of visible, hidden and selected sheets.  You will also see how many sheets are in the sheet list based on any filters that have been applied.

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)

Hide and Unhide Sheets Buttons

Hide and unhide multiple sheets at the same time.  Simply select the sheet(s) in the sheet list, then press the Hide or Unhide buttons.

You can see whether a sheet is currently visible or hidden in the second column of the sheet list.

Move Sheet Buttons

Move a sheet up, down, to the front/back of the workbook.  This is a quick way to move a sheet with the keyboard shortcuts.

Rename Sheets Button

Select one or more sheets in the sheet list, then click the Rename Sheets button to rename the selected sheets.  You can use the keyboard shortcut Alt+A to quickly rename the active sheet.

Copy & Rename Sheets Button

Make a duplicate copy of one or more sheets, and rename it all in one step.  This saves a lot of time over doing it manually with the mouse.  The keyboard shortcut is Alt+C.

Copy Sheets to New Book Button

Another time saving process that allows you to copy the selected sheets to a new workbook with the click of a button.  The keyboard shortcut is Alt+N.

Delete Sheets

Delete the selected sheet(s) with the click of a button.  The keyboard shortcut is Alt+D and you can press Enter when prompted with the warning message.

Protect & Unprotect Sheets Button

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

Table of Contents

A Table of Contents (TOC) sheet can be added to the front of the workbook with a click of a button.  The TOC sheet contains hyperlinks to each sheet in the workbook.

TOC Backlinks

A backlink to the TOC sheet can also be added to each sheet in the workbook. This makes it easy to navigate back to the Table of Contents. The following video explains how to setup the backlinks.

TOC Sheet Descriptions

Sheet Descriptions can be added to column D of the TOC sheet that give a more detailed description of the sheet.  This description text is pulled in from a cell or named range on each sheet.  For example, if cell B3 on each sheet in the workbook contains a description of that sheet, you can quickly pull this into the Table of Contents to help guide the user.

Table of Contents Add Descriptions

Bypass Menu & Warning Messages when you click the TOC button to create/update the TOC sheet with one click.  As you become familiar with how the TOC works, you might want to bypass the warning messages to make it even faster to create your TOC.  You can now turn off these warning messages in the Settings menu.

Retain Formatting when the TOC sheet is updated.  You can design your TOC sheet with custom color schemes, fonts, formulas, etc.  The custom formatting will be retained when you update the TOC sheet.

The Table of Contents Gallery feature creates a sheet with thumbnail images that link to each sheet in the workbook. This is a great way to see a preview of all the sheets in the workbook, and quickly navigate to them.

New Ribbon Buttons and Right-Click Menu

New buttons have been added to make it even easier to access some of Tab Hound’s most popular features.

Ribbon Buttons have been added to quickly Copy Sheets, Copy & Rename Sheets, and Copy Sheets to a New Book.  This makes it faster than having to open the Tab Hound window, and you can add these buttons to the Quick Access Toolbar
Tab Hound New Ribbon Buttons v1.5

Tab Right-Click Menu contains Tab Hound buttons for easy access.  When you right-click on any tab in the workbook you will see some commonly used Tab Hound commands at the bottom of the menu.  These buttons can be disabled in the settings menu if you don’t want to see them.
Tab Hound Right Click Menu

Settings Menu

The Tab Hound Settings Menu is growing with lots of new options that allow you to customize your default settings.

Tab Hound Settings Menu v1.5

  • Warning Messages can be turned on/off.  Once you are familiar with how Tab Hound operates you can turn off the warning messages to make it faster to perform actions.
  • Auto Close Tab Hound Window after actions are performed.  The Tab Hound window will automatically close when various actions are performed.  For example, when you click the Copy & Rename sheet button, the Tab Hound window will perform the action and automatically close.  You can turn this feature off and leave the Tab Hound window open.  This is nice when you are making a lot of changes at one time.
  • TOC Defaults can be set to remember your favorite settings for the TOC sheet.  Every time you create a new TOC in any workbook, these default setting will be applied.
  • Right-Click Menu buttons can be turned on/off.
  • Flip Back can be turned on/off.  If you are running a separate macro that loops through all the sheets in your workbook, you may want to temporarily disable the Flip Back recording feature.

Bug Fixes

  • I received a few reports that Excel was freezing or crashing when trying to close Excel completely.  I believe this was an issue related to the icons in the right-click menu.  I have removed those icons for now.  Please let me know if you are still having this issue.
  • Flip Back not working when sheet name was a date.  This issue has been fixed.
  • Error message when workbook was protected.  This issue has been fixed and Tab Hound will warn you to unprotect the workbook first.

Please leave a comment below with any questions. You can also contact me directly at jon@excelcampus.com.

Thank you!

Click Here to Leave a Comment Below 14 comments
Greg Tabor - October 7, 2017

I had 2 download files. I can’t get the formatting to work with either zip file. Also, I added to the Trusted List as the instructions said, but I have r=to reinstall it every time I reopen Excel. I am using Excel 2016.

Reply
DeAnn - October 29, 2016

First I want to say that I absolutely love this add in . Has already saved me time creating TOC. One thing that I am struggling with is;in the TOC Description I want a specific cell (E2)and I have to retype it every time I go to update my TOC . Is there a way to save it so I don’t have to retype it every time I update . Thank you

Reply
    Jon Acampora - November 1, 2016

    Hi DeAnn,
    Thanks for the great feedback. I’m happy to hear that Tab Hound is saving you time.

    It looks like you found a bug. The settings are stored in cell A1 on the TOC sheet, and using column E converts the string to a scientific notation number. I will fix this bug. In the meantime, you can use a cell other than column E and it should save the location. Or, you can change the format of cell A1 to Text. This should also prevent the conversion to the scientific number.

    I hope that helps. Thanks again!

    Reply
ROma - October 21, 2016

Hi I just downloaded this magic App. I am not sure how to open hidden excel sheet which are password protected.

Please will you be able to guide me.

Many thanks in advance.

Kind Regards
Roma

Reply
    Jon Acampora - October 22, 2016

    Thank you Roma!

    You should be able to unhide the sheet from the Tab Hound window. The password protection does not prevent the user from viewing the sheet. It just prevents them from modifying it. I hope that helps.

    Reply
Walt - August 31, 2016

Every time I exit Excel and then open it, the tab hound add in does not load. The box is checked in “Excel add-ins”.
I uncheck the box and then check it again. Can’t be doing this every time I open Excel. Any help would be appreciated.
Thanks.

Walt P

Reply
    Jon Acampora - September 7, 2016

    Hi Walt,

    My apologies for not getting back to you sooner. This issue with the add-in disappearing is due to an Office security update that was released by Microsoft in July. I have an article and video on how to prevent this from happening at the following link.

    Excel Add-in Ribbon Disappears and How to Get it Back

    You basically have to add the folder the add-in is saved in to the Trusted Locations list in Excel. It is a quick fix. I hope that helps. Please let me know if you have any questions. Thank you!

    Reply
Hugh Mc Bride - July 10, 2015

Hi Jon,
I love your Excel add-ins, they’ve very handy. I have a slight problem though in that when I produce a TOC it includes my very hidden sheets as well as the visible sheets. The normally hidden sheets are excluded as I expected. Is there anything I can do to help myself in this respect ?

Thanks,
Hugh

Reply
Suzy - December 2, 2014

When will we be able to copy sheets to a specific workbook?

Reply
    Jon Acampora - December 3, 2014

    Hi Suzy,
    That is a great question. I’ve had quite a few requests for it and will make it a priority. I hope to have an updated version out in January that will include that feature. Please let me know if you have any other questions or suggestions. Thank you!

    Reply
Scott - November 11, 2014

I’ve added the TabHound icons to my Quick Access Toolbar, but they keep disappearing when I relog my account. Why?

Reply
    Jon Acampora - November 20, 2014

    Hi Scott,

    This might be due to using Excel on the Citrix server. I will look into it. Thanks for letting me know.

    Reply
Jeanette Underwood - September 12, 2014

I got the download link and have installed it; however, I am looking for a receipt and did not receive one. Can someone send me a receipt?

Thanks!

Reply
    Jon Acampora - September 12, 2014

    Hi Jeanette,
    Your receipt has been sent. I’m sorry you did not receive one initially.

    Thank you for your purchase! Please let me know if you have any other questions.

    Jon

    Reply

Leave a Reply: