How to create menu/toolbar item with picture?

H

hstijnen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel 2007 with Excel 2003 template 1
Nested Sub Menus 3
Deleting custom menu item createt in VBA 1
docking a custom toolbar 3
How to run sub menu items from VBA 7
Cell Toolbar Dilemma xl2013 13
How to figure out which right-click context menu is appearing whenclicking shape/picture 2
using one macro to edit another 1

Top