Hi Shelley not sure if i understand you right but if i know what you mean it can be a pain
All i can think of is creating a summary page with hyperlinks to all the other tabs:
' Local Variables
Dim wks As Worksheet
Dim rngLinkCell As Range
Dim strSubAddress As String, strDisplayText As String
' Step 1 : Loop through all worksheets
' 1a : Clear all current hyperlinks
' 1b : Create Linked index list
For Each wks In ActiveWorkbook.Worksheets
Set rngLinkCell = Worksheets("Sheet Index").Range("A65536").End(xlUp)
If rngLinkCell <> "" Then Set rngLinkCell = rngLinkCell.Offset(1, 0)
strSubAddress = "'" & wks.Name & "'!A1"
strDisplayText = "HyperLink : " & wks.Name
Worksheets("Sheet Index").Hyperlinks.Add Anchor:=rngLinkCell, Address:="", SubAddress:=strSubAddress, TextToDisplay:=strDisplayText
create a new sheet called Sheet Index
paste the code into the this workbook module and then run it
it will create a hyperlink on 1 sheet to every other sheet in the workbook
you can then just click the 1 you want rather than scrolling through....Perhaps!?
Can this help your needs?
Start with, say, a 50 tab sheet, with first tab selected
Click Window | New Window
Then select the second tab in new window
Then click Window | Arrange | Cascade.
This is repeatable and tedious, but may be what you are looking for?
Hope so... /s/ Larry
Sorry i couldnt help...yes i forgot you would have to click back to the master sheet, only thing i can thing of is to put a button on each of the worksheets which can link you back the the sheet index.
Put this code into a command button from the forms menu, you would have to then copy the button and place it on each worksheet, but if its a workbook you use all the time its a worthwhile exercise.
Hope this helps.
PS indiantrix methd should do the trick also but you would have to repeat every time you opened the workbook.
One option would be some code that says:
for every worksheet in the workbook, click window> new window then when there are no worksheets left click window> arrange> cascade......
So sheet 1 activate window> new window
sheet 2 activate> window > new window etc until done on all workbooks then cascade....
I think this would work but ill play around with the code and get back to you, someone else might well be able to do this without playing around.
You could have the code in the workbook open event so it performs every time you open the workbook....Bare with my while i figure the code as its not my strong point!