AFAIK there is no straightforward way to do that.

It's hard enough to return the current colour of the Fill or Font dropdown
(I posted a method in this ng). To change it would probably require much of
the same method and then involve SendKeys, at least I assume that'd be the
only way.

Regards,
Peter T

"Clare.Moe" wrote in message
...
I'd like to use a VBA Macro to assign the active color of the "&Font
Color" Control on the standard Formatting toolbar (XL 2003)

Can someone point me towards documentation that will help me (or post
a solution)?

cm