scrolling through worksheets

[kestrel]

I have a workbook that has loads of worksheets, I've got different worksheets for each calendar month, and then around 10 worksheets with data on them.

At the bottom of my workbook there is the list of worksheets, I can scroll left to right to get to the one I want.

Is there a way I can have two rows for the worksheets? That way I could have all the calendar worksheets at the top and all the data worksheets at the bottom?

thanks
Leon

[dominicb]

Good afternoon Leon

No, you couldn't do that - but is this solution acceptable? With all your worksheets visible go to View > Custom Views. Click on add and give the name "All". Now hide all the calendar worksheets, and set up a custom view called "Data"... I'm sure you can see where I'm going here...? Then to access the sheets you can just switch to one of the 3 views.

In any event you don't HAVE to scroll to your worksheet - did you know that if you right click on the arrows next to the tabs a little box pops up with all your worksheets in them.

Hope some of this helps

DominicB

[dominicb]

It's me again!

Just thinking about your post and something else occured to me...

Pop this macro into your VBE screen and which when you run it will bring up a list of your sheets. Just trying to make your life a little easier...!

Sub ShowSheets()
Application.Dialogs(xlDialogActivate).Show
End Sub

DominicB