View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hstijnen hstijnen is offline
external usenet poster
 
Posts: 13
Default 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