If I create an add-in with a custom toolbar, and I create my own Faces
for the icons on the toolbar - is there anyway that I can then
programmatically assign that FaceID to another button?

Is there some problem with attaching custom toolbars to a .xla?


The reason I ask is that I want to have my own custom icons to use for
menitems, button icons, etc, without having to attach a toolbar to the
add-in.

you would need to get the icon into the clipboard, then use pasteface. You
can store the icon on a hidden sheet, then copy it to the clipboard, then
paste it to your button.

In excel 2003 (perhaps 2002) you can use the load command with a commandbar
button I believe - so your icons could be in a separate graphic file.

--
Regards,
Tom Ogilvy

"R Avery" wrote in message
...
If I create an add-in with a custom toolbar, and I create my own Faces
for the icons on the toolbar - is there anyway that I can then
programmatically assign that FaceID to another button?

Is there some problem with attaching custom toolbars to a .xla?


The reason I ask is that I want to have my own custom icons to use for
menitems, button icons, etc, without having to attach a toolbar to the
add-in.

Thank you.


Tom Ogilvy wrote:

you would need to get the icon into the clipboard, then use pasteface. You
can store the icon on a hidden sheet, then copy it to the clipboard, then
paste it to your button.

In excel 2003 (perhaps 2002) you can use the load command with a commandbar
button I believe - so your icons could be in a separate graphic file.