Toggle Sheets Toolbar
For sure, you know alt+tab shortcut in windows to toggle between launched application.
In similar way some applications use shortscut ctrl+tab - to toggle between application
windows, tabs, bookmarks, layers, etc. Excel sheets seems to be a good occasion to apply
this model. Still, if you push ctrl+tab in Excel, nothing happens. That why I decided to
create an add-in which simplify switches between Excel sheets and use also ctrl+tab
shortcut in the usual way.
Short description
Toggle Sheets is a MS Excel add-in. It helps to switch/toggle sheets in opened workbooks using keyboard shortcut or dropdown list.
Important features
- using ctrl+tab sheets can be toggled according to order in which they were activated
- any sheet can be activated choosing it from dropdown list of sheets of all opened workbooks
Excel versions
Testified in MS Excel 2002/2003/2007. It should work also in Excel 97/2000.
Install/Uninstall
Install:
- open MS Excel
- install add-in:
- MS Excel 97/2002/2003: Tools >> Add-Ins >> browse for ToggleSheets.xla >> OK
- MS Excel 2007: Office Button >> Excel Options >> Add-Ins >> choose Excel Add-Ins in Manage dropdown list >> Go... >> browse for ToggleSheets.xla >> OK
- after install the toolbar will appear:
- MS Excel 97/2002/2003: as a floating toolbar somewhere over sheet. You can catch it and put it anythere on Excel command bar.
- MS Excel 2007: on the Add-Ins ribbon. You can put it on Quick Access Toolbar: Office Button >> Excel Options >> Customize >> choose Add-Ins Tab in left dropdown list >> add Custom Toolbar >> OK
Uninstall:
- open MS Excel
- uninstall add-in:
- MS Excel 97/2002/2003: Tools >> Add-Ins >> check off ToggleSheets item >> OK
- MS Excel 2007: Office Button >> Excel Options >> Add-Ins >> choose Excel Add-Ins in Manage dropdown list >> Go... >> check off ToggleSheets item >> OK
Toolbar Controls
- list of sheets - to activate any listed sheet:
- button to toggle order of sheets in toolbar list:
- caption 123 - sheets are ordered according their order in workbook
- caption ABC - sheets are ordered alphabetically
- button to toggle between displaying all workbooks sheets or active workbook
sheets in the toolbar list :
- caption Wb - only active workbook sheets are listed
- caption Wbs - all opened workbooks sheets are listed
- additional controls at the end of list:
- _ Preferences - to edit settings of toolbar
- _ Refresh List - to refresh the list of sheets - use after renaming workbook or sheet
- _ Restart - you never know what can happen in VBA, that is why here is a possibility to start from beginning
- _ About - to show information about add-in
- keyboard shortcut ctrl+tab or ctrl+shift+tab - to toggle sheets
according to the order in which sheets were activated. The queue of sheets is
displayed in status bar, left bottom corner of application. Sheet selected in
queue is marked by brackets:
Stability
TS Toolbar should work without any problems under condition that you will not make stunts to "get it". The only weak moment comes after renaming some sheet or workbook, when the list of the sheets is actualized only after activating some other sheet or workbook (the bug is caused by the fact, that the renaming doesn't raise any event). Still this bug doesn't influence proper functionality of the toolbar.
Download
Download the TS Toolbar here.