When working with large workbooks, clicking through the tabs at the bottom of the workbook is a massive chore. I’ve seen a few different addins that offer solutions to this problem, toolbars, ribbon drop downs, userforms, there all fine, but what I really wanted was just to get rid of the tabs and have them over on the left hand side of the screen. I don’t know why Excel doesn’t not allow you to do this anyway, but it doesn’t. Clearly this was a job for a Custom Task Pane.
I quickly developed an add in that does just this, you can download it for free here:
Alternative download link: MIE_WorkSheet_Navigator_V1,
If you’re not sure how to install this addin into Excel, unzip the file and then follow the instructions here.
If you only work with large workbooks occasionally, you don’t have to install the addin. Once you have unziped the file, you can just click it like any other Excel file, and that will open the tool for that Excel “session”.
Click that and the Custom task Pane will open, (click the cross in the right hand top corner of the Custom Task Pan to close it). This picture, – click to get full size, shows you how to use it – it’s dead simple!
Please note: This addin required dot Net 4, and Excel 2007 plus, chances are you’ll be fine, if not leave a comment.
For the developers….
Custom Task Panes are not available to VBA developers, so that meant, VB6, VSTO, C++, or DNA. Guess which I picked!!!
It took me a while to workout how to get the code working from a complied .dll, but I got there in the end – I was doing something stupid. Once again XL DNA is simple, clean, and powerful, brilliant!