Charlie Jans wrote an addin for quickly switching between Excel worksheets. I’ve been using it for the last few days and I love it. For me, this is one of those addins that provides functionality that should be included in the program.
Charlie has graciously allowed me to make the addin available. You can download SheetSwitcher.zip. The zip file contains one xla file that you load like a normal addin.
To switch between sheets, use the Alt+’ key combination. It’s designed to work similar to, but not exactly like, Alt+Tab does for switching between windows application. Charlie writes that he has worked out some of the international issues that he had in his first version, but if you try it out and have any problems, I’m sure he’d like to hear about them.
The key combination is Alt plus the backward apostrophe. It’s on the same key as the tilde(~) and just to the left of the 1 key on my keyboard.
Update: Thanks to Jeremiah’s comment, I decided to add a little more to this post. (I’m not sure why I was keeping it secret:))
Before this addin, I used Control+PgUp/PgDown to switch between sheets and Control+Tab to switch between workbooks. SheetSwitcher allows you to switch between sheets regardless of the workbook. Also, the addin orders the sheets in the order you last visited them, so going back to the last sheet you visited that was in a different workbook is one keystroke away instead of several. You can only go back five sheets. Charlie made a conscious decision to limit the number of sheets available, balancing the convenience of having all the sheets available with how ugly and unusable the userform would be in that case. I think it was good choice. Thanks for the comment, Jeremiah.