Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to change font size
Hi,
I have four graphs in one worksheet and I have about 15 worksheets. It is a tiresome process to go to each and every graph to change the font size of x-axes, y-axes, bar values, x and y labels etc.... I tried using a macro to do this but it is sticking to one worksheet which i recorded the macro and doesn't change the others. Is there a way to avoid this tiresome process? Thanks Swamy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to change font size
Sub Test()
Dim ws As Worksheet Dim chtObj As ChartObject For Each ws In ActiveWorkbook.Worksheets For Each chtObj In ws.ChartObjects chtObj.Chart.ChartArea.Font.Size = 10 Next Next End Sub Regards, Peter T "Mahadevan Swamy" wrote in message oups.com... Hi, I have four graphs in one worksheet and I have about 15 worksheets. It is a tiresome process to go to each and every graph to change the font size of x-axes, y-axes, bar values, x and y labels etc.... I tried using a macro to do this but it is sticking to one worksheet which i recorded the macro and doesn't change the others. Is there a way to avoid this tiresome process? Thanks Swamy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font size on screen, but prints in old size | Excel Discussion (Misc queries) | |||
change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
Change Font Size | Excel Worksheet Functions | |||
Change the font size for Row numbers | Excel Programming |