| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA shape fill colour problem
I have a generic VBA routine that adds a specified shape to each cell within
a target range on a worksheet and defines the Shape.Fill.ForeColor.SchemeColor property and the OnAction event. The OnAction event routine then toggles the Shape.Fill.Visible property on and off which should change the colour to the already defined Shape.Fill.ForeColor.SchemeColor property and back again, but the colour always defaults to turquoise rather than the colour I've specified. This code worked fine in Excel 2003 - any guidance would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Colour problem | Excel Discussion (Misc queries) | |||
| Excel 2007 Fill Problem | Excel Discussion (Misc queries) | |||
| If I draw a shape in Excel (say a triangle), can I colour it? | Excel Worksheet Functions | |||
| How can I change the default fill colour in excel 2007 | Excel Discussion (Misc queries) | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Threaded Mode
