Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Another odd VBA glitch in 2007
With the following code 2007 will change the colours but won't change the
border lines In fact it takes out all the border lines that were already there. Anyone know a workaround? ActiveChart.SeriesCollection(2).Select With Selection.Border .Weight = xlThin .LineStyle = xlAutomatic End With Selection.Shadow = False With Selection.Interior .ColorIndex = 38 .Pattern = xlSolid |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Another odd VBA glitch in 2007
No workaround to offer, but we can give all of these a name?
YACAGG: Yet Another Carting and Graphic Glitch ?? They seem to be piling up. "teepee" wrote: With the following code 2007 will change the colours but won't change the border lines In fact it takes out all the border lines that were already there. Anyone know a workaround? ActiveChart.SeriesCollection(2).Select With Selection.Border .Weight = xlThin .LineStyle = xlAutomatic End With Selection.Shadow = False With Selection.Interior .ColorIndex = 38 .Pattern = xlSolid |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Another odd VBA glitch in 2007
"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... No workaround to offer, but we can give all of these a name? YACAGG: Yet Another Carting and Graphic Glitch ?? They seem to be piling up. Oh well I expect they'll fix them as they get round to it |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Another odd VBA glitch in 2007
I understand they're collecting these little jewels and that SP1 is already
in the works - but I would not expect to see it until late this year? "teepee" wrote: "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... No workaround to offer, but we can give all of these a name? YACAGG: Yet Another Carting and Graphic Glitch ?? They seem to be piling up. Oh well I expect they'll fix them as they get round to it |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Another odd VBA glitch in 2007
I wish they'd fix the VBA password facilty so it wasn't so easy to crack.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
office 2007 glitch disapearing text | Excel Discussion (Misc queries) | |||
vlookup glitch | Excel Worksheet Functions | |||
Anoying Excel 2007 glitch | Excel Discussion (Misc queries) | |||
Another odd VBA glitch in 2007 | Excel Discussion (Misc queries) | |||
Strange glitch | Excel Programming |