Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this work in Excel 2007? Is this a bug?
The code below is supposed to add a WordArt diamond symbol and color
it red. This works perfectly in Excel 2003, but not in 2007. What happens in 2007 is that the back color changes to red instead of the fore color. Is this a bug? Any ideas? yoffset = 15 xoffset = 184 top = 43 red = 10 Call AddDiamondSymbol(xoffset, top + yoffset, 7, 7, ChrW(&H2666), red) Function AddDiamondSymbol(left, top, height, width, tier, fillcolor) ActiveSheet.Shapes.AddTextEffect(PresetTextEffect: =0, _ Text:=tier, FontName:="Arial Black", FontSize:=20, _ FontBold:=False, FontItalic:=False, left:=left, top:=top).Select With Selection.ShapeRange .Fill.Visible = True .Fill.Solid .Fill.ForeColor.SchemeColor = fillcolor .Fill.Transparency = 0 End With End Function |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this work in Excel 2007? Is this a bug?
On 2 Apr, 02:38, "Phil" wrote:
Nevermind. Instead of banging my head on this one I decided to scrap this approach and I implemented something different. Good thinking Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Synkronizer work with Excel 2007? | New Users to Excel | |||
Excel 2007 Shortcut do not work | Excel Discussion (Misc queries) | |||
EXCEL 97 WORK IN 2007? | Excel Discussion (Misc queries) | |||
How do I work with Excel 2007 and htm files? | New Users to Excel | |||
Lost all my work in Excel 2007 | Excel Discussion (Misc queries) |