software

I want to be able to set the RGB value for a fill color in a macro. The
color palette does not have the soft pastels I want to use. The problem
stems from the fact that changes to the color palette don't carry over if I
open the worksheet on another computer. So using the ColorIndex(3) doesn't
work. I would like to do something like ColorIndex(3)= RGB(223,156,78).
Any ideas??

Thanks,

Don
Don

Does

Sub RGBColour()
Range(quot;A1quot;).Interior.Color = RGB(223, 156, 78)
End Sub

Help?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;Don McClurequot; gt; wrote in message
...
gt;I want to be able to set the RGB value for a fill color in a macro. The
gt;color palette does not have the soft pastels I want to use. The problem
gt;stems from the fact that changes to the color palette don't carry over if I
gt;open the worksheet on another computer. So using the ColorIndex(3) doesn't
gt;work. I would like to do something like ColorIndex(3)= RGB(223,156,78).
gt; Any ideas??
gt;
gt; Thanks,
gt;
gt; Don
gt;
I ran into the same problem very recently.
choose tools/option/color
choose a color you don't want to use.
click on Modify/standard
choose the color you want to use
click Ok

I tried to use the RGB function, but Excel 2003 does some weird stuff with
the RGB function.

quot;Nick Hodgequot; wrote:

gt; Don
gt;
gt; Does
gt;
gt; Sub RGBColour()
gt; Range(quot;A1quot;).Interior.Color = RGB(223, 156, 78)
gt; End Sub
gt;
gt; Help?
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt; HIS
gt;
gt;
gt; quot;Don McClurequot; gt; wrote in message
gt; ...
gt; gt;I want to be able to set the RGB value for a fill color in a macro. The
gt; gt;color palette does not have the soft pastels I want to use. The problem
gt; gt;stems from the fact that changes to the color palette don't carry over if I
gt; gt;open the worksheet on another computer. So using the ColorIndex(3) doesn't
gt; gt;work. I would like to do something like ColorIndex(3)= RGB(223,156,78).
gt; gt; Any ideas??
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; Don
gt; gt;
gt;
gt;
gt;