kemerat
The size of the sheet tabs are governed by the setting for Scrollbars in
Windows Display Appearance. Mine are at 18. Start there and work your way
up or down. The font will increase or decrease with the size of sheet tabs.
So: with Excel Application closed.
Win98 as example...
Start > Settings > Control Panel > Display > Appearance(WinXP
Appearance>Advanced)
"Item" drop down select Scrollbar
Change setting to Taste
Apply
OK
Depending upon your settings, you may have to re-boot to see the changes.
Gord Dibben Excel MVP XL2002
Also note: this is a Global change and will affect all Applications.