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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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,122,295
Messages
5,595,289
Members
413,984
Latest member
stikpet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top