View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jamesdbrown1979 jamesdbrown1979 is offline
external usenet poster
 
Posts: 5
Default 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.