Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm setting a whole list of properties for my chart, however the font.size
does not get set if Application.ScreenUpdating = false. Here is an example of the code: With ActiveChart.Axes(xlValue) .AxisTitle.Font.FontStyle = "normal" .AxisTitle.Font.Size = 11 'does not get set .TickLabels.Font.Size = 11 'does not get set .MajorGridlines.Delete .MinimumScale = -25 .MaximumScale = 125 .Crosses = xlAutomatic End With Why is this? I really prefer to keep the Application.ScreenUpdating = false. Thanks The Doctor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change Chart Properties for Multiple Chart Shts using a Worksheet | Charts and Charting in Excel | |||
Recovering chart properties in vba | Charts and Charting in Excel | |||
How to control chart properties from worksheet | Excel Discussion (Misc queries) | |||
How to control chart properties from worksheet | Charts and Charting in Excel | |||
Setting up default chart properties | Excel Programming |