Creating 2 rows of sheet tab

[jamshoot]

Hi all gurus ...

Have google search on many sites on how to create 2 rows of sheet tab at the bottom .. but most of it required complicated vba scripts which I totally don't understand at all.
Anyone have any add-in or ways to create multiple rows of sheet tab.

Cheers

 

[brans1982]

Hi,

Try...

Sub AddSheets()

For i = 1 To 5

Worksheets.Add After:=Worksheets(Worksheets.Count)

Next i

End Sub

You can change the number in bold red to what ever you want.

 

[jamshoot]

Hi,

Try...

Sub AddSheets()

For i = 1 To 5

Worksheets.Add After:=Worksheets(Worksheets.Count)

Next i

End Sub

You can change the number in bold red to what ever you want.

Hi brans1982

Thks for replying. However, this is not what I am looking for. Maybe my meaning is not clear .... anyway, what I am looking at is multiple sheets tab that can display on top of the 1st row at the bottom of excel.
Example, if there is 20 worksheets, Excel can display, depending the no. of letter u use to name the sheets, else it only display based on your screen width. So, if u need to see the last sheet, u have to click the right arrow to scroll right.
Hope my explanation is clear

Cheers

 

[monirg]

Hi jamshoot;

1) Here's what I usually do:
--> right-click anywhere at the far left of the tab row
(where you see: |< < > >|)
--> a pop-up displays all the sheets in the workbook
--> select whatever sheet you want to see

2) It would be interesting if someone knows how to display "2 rows of sheet tabs"
Say you have 20 sheets in a workbook, and you want the tabs to be displayed:
Sheet1 to Sheet10 in one row
and below it
Sheet11 to Sheet20
Is that even possible in XL 2003 ??

Regards.

 

[monirg]

Hello;

Monir wrote:
1) Here's what I usually do:
--> right-click anywhere at the far left of the tab row
(where you see: |< < > >|)
--> a pop-up displays all the sheets in the workbook
--> select whatever sheet you want to see

2) It would be interesting if someone knows how to display "2 rows of sheet tabs"
Say you have 20 sheets in a workbook, and you want the tabs to be displayed:
Sheet1 to Sheet10 in one row
and below it
Sheet11 to Sheet20
Is that even possible in XL 2003 ??

OK. Is it possible in XL 2010 ??

Regards.

 

[VoG]

It isn't possible in any version of Excel.

 

[monirg]

Thank you Peter for your prompt answer.

Regards.