Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
greetings all,
I am trying to create a custom command bar with some self designed icons. these icons reside in an excel file as pictures(bitmaps). some of these icons are images to replace MS menu items that have text only on some are special functions i have designed. but i cannot get the custom icons to paste. here is my test code. Sub macTestcomandbar() Dim MyControl As CommandBarButton Application.CommandBars.Add(Name:="atest1").Visibl e = True Application.CommandBars("atest1").Controls.Add Type:=msoControlButton, _ ID:= 752, befo=1 'MS Exit ActiveSheet.Shapes("Picture 79").CopyPicture 'pic of open door with arrow Set MyControl = CommandBars.FindControl(Type:=msoControlButton, ID:=752) MyControl.PasteFace End Sub I have done a search on the PasteFace in this descussion group and in excel help. the pasteface is suppost to do it but it doesn't seem to order on my pc. Did i miss something. help and/or guidance would be appreciated. Thanks in advance. FSt1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom icon | Excel Discussion (Misc queries) | |||
custom icon buttons | Excel Programming | |||
Using vbCritical, vbQuestion, etc icon in custom dialogs | Excel Programming | |||
custom borders icon to use on the tool bar | Excel Discussion (Misc queries) | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming |