Navigating a large spreadsheet (continued)...
This addin installs a CommandBar with a drop down list of all the visible worksheets in the workbook. It will update as you add or delete sheets, or change workbooks. It is particularly useful in large workbooks.
Click to enlarge
The addin is designed so that it will work in any workbook that you activate, immediately updating to show that workbook's sheets.
Install the addin
The zipped file contains the addin & an installer workbook. Extract both workbooks to the same folder. The easiest way to install the addin is with the installer, simply open the JR_InstallAddin.xls workbook & follow the instructions. There is an inbuilt uninstall command if you no longer want to use the addin. Simple help is included.
Click here to download
AddTOC - Table of Contents
This addin can be used to quickly & simply add a Table of Contents page to any Workbook. It will also add hyperlinks to the Worksheets. The zip file contains the addin and a workbook that can be used to automate the correct installation of this addin.
Click here to download the addin