View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Custom face for custom toolbar item


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?