Ive just been upgraded to Excel 2007. In the old Excel version, one could
add a drop-down box to the toolbar for formatting the pattern color and
pattern styles of a cell. It looked and functioned a lot like the "fill
color" button.
I can't seem to find its counterpart in the 2007 version -- neither on the
ribbon, or in the available buttons for the toolbar. I used this button
CONSTANTLY! In the new version, I have to open the font dialogue box, click
to the fill page, click on the pattern color box, then on the pattern style
box €“ seven clicks in all €“ every time I want to change a new cell area! In
the old version of Excel, it took one click on the toolbar to paste in the
color and pattern that Id used last, or three clicks to choose a new scheme.

Is there an add-on, or a macro that I can use to recreate the button as it
existed in the old version of Excel? Id love to be able to add it to the
€˜font area of the ribbon €“ but adding it to the toolbar would do as well.

User customizations are intended to be handled in the Quick Access toolbar:

"The Quick Access Toolbar is designed to make it easy to add controls,
galleries, and groups from anywhere in the Ribbon: just right-click the thing
you want to add and choose 'Add to Quick Access Toolbar' from the context
menu. "

--
Regards,
Tom Ogilvy


"Candida" wrote:

Ive just been upgraded to Excel 2007. In the old Excel version, one could
add a drop-down box to the toolbar for formatting the pattern color and
pattern styles of a cell. It looked and functioned a lot like the "fill
color" button.
I can't seem to find its counterpart in the 2007 version -- neither on the
ribbon, or in the available buttons for the toolbar. I used this button
CONSTANTLY! In the new version, I have to open the font dialogue box, click
to the fill page, click on the pattern color box, then on the pattern style
box €“ seven clicks in all €“ every time I want to change a new cell area! In
the old version of Excel, it took one click on the toolbar to paste in the
color and pattern that Id used last, or three clicks to choose a new scheme.

Is there an add-on, or a macro that I can use to recreate the button as it
existed in the old version of Excel? Id love to be able to add it to the
€˜font area of the ribbon €“ but adding it to the toolbar would do as well.

Thank you Tom -- but I looked there before writing to you. It is no longer
available, unless they've named it something undiscernable. I looked in all
the command lists, and can't find it. That's why I'm looking for a macro or
add-on. Is there one?


"Tom Ogilvy" wrote:

User customizations are intended to be handled in the Quick Access toolbar:

"The Quick Access Toolbar is designed to make it easy to add controls,
galleries, and groups from anywhere in the Ribbon: just right-click the thing
you want to add and choose 'Add to Quick Access Toolbar' from the context
menu. "

--
Regards,
Tom Ogilvy


"Candida" wrote:

Ive just been upgraded to Excel 2007. In the old Excel version, one could
add a drop-down box to the toolbar for formatting the pattern color and
pattern styles of a cell. It looked and functioned a lot like the "fill
color" button.
I can't seem to find its counterpart in the 2007 version -- neither on the
ribbon, or in the available buttons for the toolbar. I used this button
CONSTANTLY! In the new version, I have to open the font dialogue box, click
to the fill page, click on the pattern color box, then on the pattern style
box €“ seven clicks in all €“ every time I want to change a new cell area! In
the old version of Excel, it took one click on the toolbar to paste in the
color and pattern that Id used last, or three clicks to choose a new scheme.

Is there an add-on, or a macro that I can use to recreate the button as it
existed in the old version of Excel? Id love to be able to add it to the
€˜font area of the ribbon €“ but adding it to the toolbar would do as well.

http://office.microsoft.com/en-us/ex...0481033.aspx#2

The quick access toolbar is still there.

http://www.rondebruin.nl/0307commands.htm

"Or faster,right click on the QAT and choose "Customize Quick Access Toolbar""

--
Regards,
Tom Ogilvy




"Candida" wrote:

Thank you Tom -- but I looked there before writing to you. It is no longer
available, unless they've named it something undiscernable. I looked in all
the command lists, and can't find it. That's why I'm looking for a macro or
add-on. Is there one?


"Tom Ogilvy" wrote:

User customizations are intended to be handled in the Quick Access toolbar:

"The Quick Access Toolbar is designed to make it easy to add controls,
galleries, and groups from anywhere in the Ribbon: just right-click the thing
you want to add and choose 'Add to Quick Access Toolbar' from the context
menu. "

--
Regards,
Tom Ogilvy


"Candida" wrote:

Ive just been upgraded to Excel 2007. In the old Excel version, one could
add a drop-down box to the toolbar for formatting the pattern color and
pattern styles of a cell. It looked and functioned a lot like the "fill
color" button.
I can't seem to find its counterpart in the 2007 version -- neither on the
ribbon, or in the available buttons for the toolbar. I used this button
CONSTANTLY! In the new version, I have to open the font dialogue box, click
to the fill page, click on the pattern color box, then on the pattern style
box €“ seven clicks in all €“ every time I want to change a new cell area! In
the old version of Excel, it took one click on the toolbar to paste in the
color and pattern that Id used last, or three clicks to choose a new scheme.

Is there an add-on, or a macro that I can use to recreate the button as it
existed in the old version of Excel? Id love to be able to add it to the
€˜font area of the ribbon €“ but adding it to the toolbar would do as well.

I'm sorry - it seems I'm not making myself clear. I am familiar with the
quick access toolbar, I've already modified it quite a bit. However, the
button I'm looking for (cell pattern-style) was left off the list of
available commands for the toolbar in Excel 2007. It was available in
previous versions.

"Tom Ogilvy" wrote:

http://office.microsoft.com/en-us/ex...0481033.aspx#2

The quick access toolbar is still there.

http://www.rondebruin.nl/0307commands.htm

"Or faster,right click on the QAT and choose "Customize Quick Access Toolbar""

--
Regards,
Tom Ogilvy




"Candida" wrote:

Thank you Tom -- but I looked there before writing to you. It is no longer
available, unless they've named it something undiscernable. I looked in all
the command lists, and can't find it. That's why I'm looking for a macro or
add-on. Is there one?


"Tom Ogilvy" wrote:

User customizations are intended to be handled in the Quick Access toolbar:

"The Quick Access Toolbar is designed to make it easy to add controls,
galleries, and groups from anywhere in the Ribbon: just right-click the thing
you want to add and choose 'Add to Quick Access Toolbar' from the context
menu. "

--
Regards,
Tom Ogilvy


"Candida" wrote:

Ive just been upgraded to Excel 2007. In the old Excel version, one could
add a drop-down box to the toolbar for formatting the pattern color and
pattern styles of a cell. It looked and functioned a lot like the "fill
color" button.
I can't seem to find its counterpart in the 2007 version -- neither on the
ribbon, or in the available buttons for the toolbar. I used this button
CONSTANTLY! In the new version, I have to open the font dialogue box, click
to the fill page, click on the pattern color box, then on the pattern style
box €“ seven clicks in all €“ every time I want to change a new cell area! In
the old version of Excel, it took one click on the toolbar to paste in the
color and pattern that Id used last, or three clicks to choose a new scheme.

Is there an add-on, or a macro that I can use to recreate the button as it
existed in the old version of Excel? Id love to be able to add it to the
€˜font area of the ribbon €“ but adding it to the toolbar would do as well.

I hope someone might have an answer???

"Candida" wrote:

I'm sorry - it seems I'm not making myself clear. I am familiar with the
quick access toolbar, I've already modified it quite a bit. However, the
button I'm looking for (cell pattern-style) was left off the list of
available commands for the toolbar in Excel 2007. It was available in
previous versions.

"Tom Ogilvy" wrote:

http://office.microsoft.com/en-us/ex...0481033.aspx#2

The quick access toolbar is still there.

http://www.rondebruin.nl/0307commands.htm

"Or faster,right click on the QAT and choose "Customize Quick Access Toolbar""

--
Regards,
Tom Ogilvy




"Candida" wrote:

Thank you Tom -- but I looked there before writing to you. It is no longer
available, unless they've named it something undiscernable. I looked in all
the command lists, and can't find it. That's why I'm looking for a macro or
add-on. Is there one?


"Tom Ogilvy" wrote:

User customizations are intended to be handled in the Quick Access toolbar:

"The Quick Access Toolbar is designed to make it easy to add controls,
galleries, and groups from anywhere in the Ribbon: just right-click the thing
you want to add and choose 'Add to Quick Access Toolbar' from the context
menu. "

--
Regards,
Tom Ogilvy


"Candida" wrote:

Ive just been upgraded to Excel 2007. In the old Excel version, one could
add a drop-down box to the toolbar for formatting the pattern color and
pattern styles of a cell. It looked and functioned a lot like the "fill
color" button.
I can't seem to find its counterpart in the 2007 version -- neither on the
ribbon, or in the available buttons for the toolbar. I used this button
CONSTANTLY! In the new version, I have to open the font dialogue box, click
to the fill page, click on the pattern color box, then on the pattern style
box €“ seven clicks in all €“ every time I want to change a new cell area! In
the old version of Excel, it took one click on the toolbar to paste in the
color and pattern that Id used last, or three clicks to choose a new scheme.

Is there an add-on, or a macro that I can use to recreate the button as it
existed in the old version of Excel? Id love to be able to add it to the
€˜font area of the ribbon €“ but adding it to the toolbar would do as well.

As far as I know it is gone

This will not work in 2007 for example

Application.CommandBars.FindControl(ID:=1988).Exec ute

And for example 23 (open dialog ) is working correct

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Candida" wrote in message ...
I hope someone might have an answer???

"Candida" wrote:

I'm sorry - it seems I'm not making myself clear. I am familiar with the
quick access toolbar, I've already modified it quite a bit. However, the
button I'm looking for (cell pattern-style) was left off the list of
available commands for the toolbar in Excel 2007. It was available in
previous versions.

"Tom Ogilvy" wrote:

http://office.microsoft.com/en-us/ex...0481033.aspx#2

The quick access toolbar is still there.

http://www.rondebruin.nl/0307commands.htm

"Or faster,right click on the QAT and choose "Customize Quick Access Toolbar""

--
Regards,
Tom Ogilvy




"Candida" wrote:

Thank you Tom -- but I looked there before writing to you. It is no longer
available, unless they've named it something undiscernable. I looked in all
the command lists, and can't find it. That's why I'm looking for a macro or
add-on. Is there one?


"Tom Ogilvy" wrote:

User customizations are intended to be handled in the Quick Access toolbar:

"The Quick Access Toolbar is designed to make it easy to add controls,
galleries, and groups from anywhere in the Ribbon: just right-click the thing
you want to add and choose 'Add to Quick Access Toolbar' from the context
menu. "

--
Regards,
Tom Ogilvy


"Candida" wrote:

Ive just been upgraded to Excel 2007. In the old Excel version, one could
add a drop-down box to the toolbar for formatting the pattern color and
pattern styles of a cell. It looked and functioned a lot like the "fill
color" button.
I can't seem to find its counterpart in the 2007 version -- neither on the
ribbon, or in the available buttons for the toolbar. I used this button
CONSTANTLY! In the new version, I have to open the font dialogue box, click
to the fill page, click on the pattern color box, then on the pattern style
box €“ seven clicks in all €“ every time I want to change a new cell area! In
the old version of Excel, it took one click on the toolbar to paste in the
color and pattern that Id used last, or three clicks to choose a new scheme.

Is there an add-on, or a macro that I can use to recreate the button as it
existed in the old version of Excel? Id love to be able to add it to the
€˜font area of the ribbon €“ but adding it to the toolbar would do as well.