Quote Originally Posted by VBA Noob
Would this link help

http://www.contextures.com/xlToolbar01.html

VBA Noob
This is helpful, but I would actually prefer instead of it being a drop down box, the list would just stay fixed. It would be a little busy in the worksheet, but if you have 30 tabs it would be nice to have them in a list like that so you can just have them all right there at your fingertips.