A simple sheet changing add-in
September 23, 2008 • JP • No Comments • Rate 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.
See you at the Excel User Conference!
–JP
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
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 »
Previous Post: Hold that email!
Next Post: My Excel User Conference Experience
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].