custom icon in custom commandar

T

Tim Rush

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" ?????
 
S

Sam Wilson

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
 
T

Tim Rush

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!
 

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

Top