A simple sheet changing add-in

September 23, 2008 – 7:06 pm by JP

I wrote a small add-in that lets you switch between worksheets easily. Just download the XLA file, place in your favorite directory, and go to Tools > Add-Ins and browse for the file.

When installed, a menu item on the Windows menu called “Sheet Picker” is added. A form with a list of all the available worksheets appears. Just pick one and click “Go To Sheet” to switch to that sheet. The “Exit” button shuts down the form. It’s pretty primitive so let me know if there are any bugs.