Escel 2003 has a nice feature for creating & editing custom faces for toolbar
items, but this activity does not register in the macro recorder. Are these
faces saved as icon files? If so, can they be assigned to toolbar items in
code?

All custom faces for toolbar buttons are given the same FaceID of 1.
So no, they are not dumped into a file someplace for easy retrieval.
You can of course save a picture someplace and then figure out a way
to add it to a custom toolbar button. But that doesn't seem to be a
popular discussion item in these newsgroups.
The actual menu/toolbar configuration is saved in a file with an .xlb
extension. It is subject to occasional bloat and corruption.

However, Excel does have a library of toolbar pictures and with each
new version of Excel, adds more to the library. They are numbered from
1 to about 10,000 (currently ). If you see one you like, it can be added to
any toolbar button with the vba command of ...FaceId = 123, or by a simple
manual copy and paste.

There are several utilities (all free) out there that provide some sort of
scrolling display of all the button faces. See a picture you like, copy and paste it.

Send me an email request, with your name and location and I'll send you the
one I developed from an old Microsoft program.
I think it is one of the best.
(parents do tend to favor their children) <g
Remove xxx from my email address.
XX
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Allen_N"
wrote in message
Escel 2003 has a nice feature for creating & editing custom faces for toolbar
items, but this activity does not register in the macro recorder. Are these
faces saved as icon files? If so, can they be assigned to toolbar items in
code?

Tks Jim, your tools help me to easily choose faceid for the command
toolbar
kr
Pascal

On 29 déc 2006, 02:26, "Jim Cone" wrote:
Allcustomfaces fortoolbarbuttons are given the same FaceID of 1.
So no, they are not dumped into a file someplace for easy retrieval.
You can of course save a picture someplace and then figure out a way
to add it to acustomtoolbarbutton. But that doesn't seem to be a
popular discussionitemin these newsgroups.
The actual menu/toolbarconfiguration is saved in a file with an .xlb
extension. It is subject to occasional bloat and corruption.

However, Excel does have a library oftoolbarpictures and with each
new version of Excel, adds more to the library. They are numbered from
1 to about 10,000 (currently ). If you see one you like, it can be added to
anytoolbarbutton with the vba command of ...FaceId = 123, or by a simple
manual copy and paste.

There are several utilities (all free) out there that provide some sort of
scrolling display of all the button faces. See a picture you like, copy and paste it.

Send me an email request, with your name and location and I'll send you the
one I developed from an old Microsoft program.
I think it is one of the best.
(parents do tend to favor their children) <g
Remove xxx from my email address.

--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware

"Allen_N"
wrote in message
Escel 2003 has a nice feature for creating & editingcustomfaces fortoolbar
items, but this activity does not register in the macro recorder. Are these
faces saved as icon files? If so, can they be assigned totoolbaritems in
code?