View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default creating a commandbarbutton with a custom bitmap

You need to get the bitmap in the clipboard and then use the pasteface
method to paste it on your button.

You could store the bitmaps on a hidden worksheet and copy them to the
clipboard.

In Excel 2002, I believe they have added a picture property to the buttons
and you can use the loadpicture function like for msforms controls.

Regards,
Tom Ogilvy




"Kris Van Baelen" wrote in message
...
Hi,

We want to programmatically create a commandbarbutton on a
new commandbar with a custom bitmap. We managed to create
commandbarbuttons with built-in images, but cannot find
out how to deal with custom bitmaps. Is there a way to do
this in Office2000?

TIA,

Kris