fill color toolbar buttons for specific colors

[bucky3]

Is there a way to have multiple toolbar buttons that fill different
colors? For example, one toolbar button for fill blue, another to fill
red, another to fill yellow.

Currently, to work with several colors, I need to click to get to the
fill palette, then select the color. Quite tedious and slow.

 

[Don Guillett]

One way would be to have a macro for each assigned to a custom button on a
toolbar.

 

[Bob Phillips]

Is that what the built-in fill colour toolbar button does?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

But that takes two clicks, Bob........very tedious and slow.


Gord

 

[Andy Pope]

Hi,

As long as you don't have xl2007 you can tear the drop down part of the
control off and make it float.
Press the dropdown button and then click on the blue header bar and drag
it away from the button.

Cheers
Andy

 

[Gord Dibben]

Good point Andy.

Why do I always forget that?


Gord

 

[Don Guillett]

And, why didn't I know it? Duh!!