Thread: Making Tab Sizes smaller or creating multiple rows of tabs.

I have been trying to figure out a way that I don't have to constantly scroll around my worksheets looking for the right tab. Some of them have 30+ tabs. I found this way to decrease tab size

http://www.asap-utilities.com/excel-...egorie=9&m=115

But I am not totally happy with it. Is there a way to create multiple rows of tabs or other ways of making them smaller to reduce scrolling around looking for tabs.

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.

Originally Posted by VBA Noob

In the bottom right sheet that are 4 arrows two left and two right <<>>. Right click on these arrows and a list of all the worksheets will appear

VBA Noob

Weird never noticed that, but that still isn't quite what I want. When you right click on the arrows the list will only stay until you click away. Basically i want the list to stay there constantly, like the tool bar, while I am working on my excel sheet. Sorry, I am so demanding.

Thanks though