A simple sheet changing add-in

September 23, 2008JPNo CommentsRate This Article


    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.

Code Locked Versions:

Sheet Picker Add-In – Excel 2000-2003 version
Sheet Picker Add-In – Excel 2007 version

Code UN-Locked Versions:

Sheet Picker Add-In – Excel 2000-2003 version
Sheet Picker Add-In – Excel 2007 version

    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.

sheetpicker 1

    See you at the Excel User Conference!

–JP

About JP
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »

↑ Scroll to top
Previous Post:

Next Post:

Speak Your Mind

Tell us what you're thinking...

Certain comments (including first-time comments) are subject to moderation and will not appear immediately. Please view the Comment Policy for more information. To post VBA code in your comment, use tags like this: [cc lang='vb']Code goes here[/cc].




Site last updated July 26, 2010 @ 8:14 pm