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
|