To change the font size of the sheets tab:
1. Minimize all open applications by pressing +M (the key is between the Ctrl and Alt keys), and right-click the desktop.
2. Select Properties, and then select the Appearance tab.
3. Click Advanced (skip this step if using Windows 98).
4. From the Item dropdown list, choose Scrollbar.
5. Change the Size and click OK twice.
Screenshot // Changing the Font Size of the Sheet Name
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
It's not work. Because, it's chang tab size but not font size on sheet tab.