Tab font size

bodhi

New Member
Joined
Dec 22, 2005
Messages
2
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?

:rolleyes:
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Pericic

Board Regular
Joined
Nov 11, 2005
Messages
204
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

New Member
Joined
Dec 22, 2005
Messages
2
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,811
Messages
5,574,449
Members
412,595
Latest member
slim313
Top