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 ([email protected]) with any questions.
Sorry for not responding earlier as the videos were blocked due to my organization’s restriction.
(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”.
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!
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
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! 🙂
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)?
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!
Great add in which has helped to navigate around large spreadsheets with ease.
Thanks Mark!
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.
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!
Yes, updating Office 2016 resolved both issues.
Thanks.
Ok, great. Thanks for letting me know!
any possibilities to have a copy of the commands to another ribbon tabs ?
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!
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?
It would be nice if there is a button which actually sort the sheets in the worksheets and not only the list.
Wish I knew about Tab Hound 5,000 clicks of the left/right tab arrows ago.
Jon,
Copying sheets to a new workbook would be enhanced by copying to ANOTHER workbook. When invoked, it should prompt for a workbook name and copy the sheets to the back of that workbook. But, if no workbook name is given, then the copy is done on a new sheet. Any thoughts?