ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to create menu/toolbar item with picture? (https://www.excelbanter.com/excel-programming/388117-how-create-menu-toolbar-item-picture.html)

hstijnen

How to create menu/toolbar item with picture?
 
Hi,

I'm trying to create a .xla that creates some new menu or toolbar items to
call its functions. Using Excel 2000 VBA. That works. Now I want to add a
custom made icon to the new item.
I've found some usefull code:
Set SubMenu = CommandBars(€ťSculpt€ť).Controls(€ťSculptIcon€ ť)
With SubMenu
.Picture = LoadPicture(strPath & €śSculpt.bmp€ť)
.Mask = LoadPicture(strPath & €śSculptMask.bmp€ť)
End With

However I get an error for:
.Picture = LoadPicture(strPath & €śSculpt.bmp€ť)

Picture seems not a member of CommandBarControl. And in Help I cannot find it.

What is the matter? Does it only work from Excel 2003 and not in Excel 2000?

Any suggestions?

Regards, Henkl


All times are GMT +1. The time now is 07:24 PM.

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