I want to load an icon image (.ico file) to a
CommandBarButton. How can I do this?

I know CommandBarButton has the method "PasteFace", but
this requires the image first copied onto the clipboard. I
don't think (can I?) I can load an .ico file directly to
clipboard.

Any solution?

--

HTH

Bob Phillips

"Gary Chan" wrote in message
...
I want to load an icon image (.ico file) to a
CommandBarButton. How can I do this?

I know CommandBarButton has the method "PasteFace", but
this requires the image first copied onto the clipboard. I
don't think (can I?) I can load an .ico file directly to
clipboard.

Any solution?

Bob,

Do you have a "loose trigger finger" or a problem with Outlook (no pun
intended). Many of your posts are preceded with a blank response...

--
sb
"Bob Phillips" wrote in message
...


--

HTH

Bob Phillips

"Gary Chan" wrote in message
...
I want to load an icon image (.ico file) to a
CommandBarButton. How can I do this?

I know CommandBarButton has the method "PasteFace", but
this requires the image first copied onto the clipboard. I
don't think (can I?) I can load an .ico file directly to
clipboard.

Any solution?

Gary,

In essence, you need to have the icons as an image somewhere and load the
shape. I do this by putting them on a hidden sheet on the workbook that the
commandbar is created from, with code somewhat like

cbTable.Shapes(shapename).CopyPicture
cbCtl.PasteFace

where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30', and cbCtl is an object
variable for the control being added.

If you want to use the builtin faceids, you would use something like

cbCtl.FaceId = faceIdNum


--

HTH

Bob Phillips

"Gary Chan" wrote in message
...
I want to load an icon image (.ico file) to a
CommandBarButton. How can I do this?

I know CommandBarButton has the method "PasteFace", but
this requires the image first copied onto the clipboard. I
don't think (can I?) I can load an .ico file directly to
clipboard.

Any solution?