![]() |
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