Increase your productivity with the Hyper Navigation utility.
If you're tired of looking through dozens of worksheets trying to find data, watch this free Hyper Navigation Macro video tutorial.
You'll learn how to produce an easy to use tool to help you analyze and compare data more efficiently.
Best yet, the macro takes less than 5 minutes to write.
To download the workbook accompanying this tutorial, click on the following link:
This video is an excerpt from the VBA Training CD. It explains how to create the Hyper Navigation utility in Excel 2007 and Excel 2010.
To learn how to create the same utility in Excel 2003, click here.
You can right click on the sheet tabs navigation arrows to get the same functionality.
Or is this just for tutorial purposes?
Regards
Brian
Thanks for your question Brian. You’re right to say that part of the video was to introduce users to programming in the VBE.
Moreover, when working with larger workbooks – which is especially the case in many office and corporate environments – there are a couple ways the Hyper Navigation utility saves time.
First, it halves the number of clicks and reduces the mouse distance traveled for each navigation. Rather than right clicking and then left clicking the desired worksheet, you can select the sheet directly from the menu in one click.
Secondly, right clicking on the navigation arrows only displays a certain number sheets. Displaying all sheets like the Hyper Navigation utility requires yet an additional click.
There are certainly occasions when just clicking on the worksheet tabs will work almost as well. However, when dealing with a larger number of worksheets, the utility will end up saving you a great deal of time.