Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom icon in custom commandar
I create a custom commandbar/menu that loads when the workbook opens.
I'd like to add my own icons to the those commands, and not use the ..faceID's that are included in Excel (2003). Is there a command to add an icon based on a file pointer or something. Sort of like With mysubmenuitem .caption="Item name" .face = "Point to my Icon here" ????? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom icon in custom commandar
I use a hidden sheet (sheet 1, say) as follows:
sheet1.shapes("blahblah").copy with .mysubmenuitem .caption = "Item Name" .pasteface end with I made 'blahblah' by editing an existing icon in excel, and then copying that into a cell on sheet 1 and changing its name to blahblah "Tim Rush" wrote: I create a custom commandbar/menu that loads when the workbook opens. I'd like to add my own icons to the those commands, and not use the .faceID's that are included in Excel (2003). Is there a command to add an icon based on a file pointer or something. Sort of like With mysubmenuitem .caption="Item name" .face = "Point to my Icon here" ????? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom icon in custom commandbar
Then I suppose creating a series of 'shapes' on my Personal.xls file would
allow me to use any number of icons throughout all my files by selecting the sheet in that workbook. It should work, though a bit of an unusual method. Thanks! "Sam Wilson" wrote: I use a hidden sheet (sheet 1, say) as follows: sheet1.shapes("blahblah").copy with .mysubmenuitem .caption = "Item Name" .pasteface end with I made 'blahblah' by editing an existing icon in excel, and then copying that into a cell on sheet 1 and changing its name to blahblah "Tim Rush" wrote: I create a custom commandbar/menu that loads when the workbook opens. I'd like to add my own icons to the those commands, and not use the .faceID's that are included in Excel (2003). Is there a command to add an icon based on a file pointer or something. Sort of like With mysubmenuitem .caption="Item name" .face = "Point to my Icon here" ????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom icon | Excel Discussion (Misc queries) | |||
Custom Icon for an Excel File | Excel Programming | |||
custom icon buttons | Excel Programming | |||
custom icon buttons | Excel Programming | |||
custom borders icon to use on the tool bar | Excel Discussion (Misc queries) |