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
|