ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   creating a commandbarbutton with a custom bitmap (https://www.excelbanter.com/excel-programming/271434-re-creating-commandbarbutton-custom-bitmap.html)

Tom Ogilvy

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





All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com