Tab font size

[bodhi]

Hi Everyone,

I am relatively new to Excel and VBA but am slowly coming to grips with it all.

I have a problem that seems like it would be easy to fix but am unsure of how to do it.

Is there any way that I can change the size and/or style of the font on a worksheet tab?

 

[Pericic]

This parameter is determined by a Windows system-wide setting. To change it, select Start, Settings, Control Panel and double-click Display. In the Display Properties dialog box, click the Appearance tab, and choose Scrollbar from the Item list. Adjust the sheet tabs until they're the size you want. Be aware that this setting affects the scroll bars in all your applications.

From www.j-walk.com

 

[bodhi]

Pericic, thanks for the info. I'll have a play with it and see how things go.

I was hoping to be able to change this only for Excel and not all applications.

Is anyone aware if manipulating the tab fonts can be achieved by API's or another method?