Re: What icon in Excel 2007 does the pattern shading?

This sounds like a custom button, added to the boxed version of Excel.
You'll have to similarly modify Excel 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John Nettles" <JohnNettles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42FA0591-B23B-47B7-B472-3382E1A414DA@xxxxxxxxxxxxxxxx
I appreciate you responding but while know and understand that control 1 is
a
mini-shortcut to the format cells overall box, I am looking for the icon
that
is one step, i.e. like the "comma" symbol on the little icon/toolbar
command
that makes the numer in the cell a "1,2345.67" format versus a 12345.67"
format a 1-step process. The older version of Excel had the icon/toolbar
command for giving a user-defined default cell pattern background but I
can
not find it on the 2007 version. Thanks again.

"Tyro" wrote:

You can modify the ribbon in Excel 2007 with VBA. The icons are in
Winows/sytem32 somehwere, I have forgotten where. Others know.

Tyro

"John Nettles" <JohnNettles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2F1AEEFA-E599-4D56-AABE-504057048143@xxxxxxxxxxxxxxxx
Thanks for responding but maybe I didn't make myself clear enough. I
understand how to get the cell shaded with a pattern, I would like to
know
what the icon is called or look like. For instance the "open an
exisiting
file" icon is the pic of the file folder opened with a little arrow
above
it.
I am looking for the "1 click" icon for doing the pattern shading (cell
has
background of shaded dots). Thanks again, John

"Tyro" wrote:

Home/Font section,select the dialog launcher. Or simply Ctrl+1. This
brings
up Format Cells. Select the fill tab and go from there.

Tyro

"John Nettles" <John Nettles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:DC1DD7DC-BB19-47ED-8145-9B2570902316@xxxxxxxxxxxxxxxx
I do a lot of shading (Home > Font > Fill > Pattern Style) and I can
not
determine what icon it is in this new version. Any help would be
appreciated? Also, is there a list of icons that can be determined
by
entering where it is located, i.e. see above for shading? Thanks!!








.